User Community

Monthly percentage of annual value

Hello, I have created a line chart showing the monthly distribution of reported sales. I tried to add a tip tool that shows the percentage of the month's value relative to the annual value.…

create hierarchy without access to the model

Can I create a hierarchy of dimensions without access to the model? (In discover or formulate)

• Answered

Last month of Quarter - Date Lists & Formulates

I need to create a rollforward which is a Quarterly rollforward (see SNIP below of rough draft). This will past 5 quarters of data. I will be creating formulas for each of the listed items (Beginning…

Add User Search Box within the Role Management Panel

Hello PA Team, I'd like to suggest a simple but very important usability enhancement for the role management interface in the Admin Console. Currently, when I open a role to manage its members,…

Add "Select All" Option to Multi Select Tree

Hello PA-Team! It would be highly beneficial to add a "Select All" option to the Multi Select Tree slicer, similar to the functionality already available in the Multi Select Drop Down slicer.…

How to rename the forecast label

Hello, When I use the forecast tool I get Forcast1, forecast 2, forecast 3... I also do see an option to change the word forecast , but what I don't know is how I change it to be the next 6 months.…

• Answered

Load a whole folder and append multiple same-structure CSV file

Greetings! I looking for a way to load and append a whole set of files into Pyramid (same-structure files from different divisions, or from different days).…

• Answered

Column chart: data labels inside/outside & text direction

Hi, I created a column chart in Pyramid 2018. how can I put the data labels outside the column? And can I change the text direction to horizontal? Thanks in advance! Regards, Rutger Lammers.

• Answered

Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula

I have a report example that shows values accumulating over a two-year time frame. If, at any point, the value for a specific Part/Type falls below a defined threshold,…

• Answered