How can I show the scenario variance and YoY variance in the same table? I’d also like to be able to collapse month » quarter » year as needed. Currently, it’s showing YoY columns for all scenarios.
Also, is there a way to restrict which metrics a calculated item pertains to?
Lastly, is there a way to hide columns in a table?
Thanks!
Hi Harshil
To start off with the first question, yes - you can show scenario variance and YoY variance in the same table. For this, you should open your table --> click on 'Pivot' --> Find the 'Scenario' selection and click on the ellipsis (...) to open the menu. Select 'Add Calculated item' --> 'Custom calculation'. From here you can select the Scenarios you want to compare as Item A and Item B.
Similar process can be completed when setting up YoY variance, except you need to select the 'Year' dimension and use one of the YoY calculations from the menu:
Pigment also allows to expand and collapse dimensions by clicking on the small 'minus' or 'plus' signs beside the column/row header.
Finally, to hide a column, you can select the column you want to hide and click on the ‘down arrow’ icon at the top right corner of the column:
Then select 'Hide item' from the menu.
To unhide the column, you can click on the 'Filter' icon at the top menu bar and delete/edit the filter item which is hiding the column.
I hope you find this information useful!
Thanks
Hi
The issue with this approach “Similar process can be completed when setting up YoY variance, except you need to select the 'Year' dimension and use one of the YoY calculations from the menu” is that it doesn’t calculate the YoY for the quarters or months in that year. Do you know how to resolve this?
Also, I don’t see a “Hide Item” option for the column I want to hide (red column below).
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
