Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have various expressions in the pivot table which are calculated on different time base, therefore I want to categorize them for more readable. It will looks like below. Is it possible to achieve? Thanks!
current month | YTD | |||
actual | forecast | actual | forecast | |
a | 10 | 9 | 50 | 45 |
b | 12 | 15 | 60 | 70 |
c | 14 | 14 | 55 | 60 |
therefore I want to categorize them for more readable.
What does that mean? Categorize what in which way? What are the categories?
Maybe just create another dimension, using a stand-alone table in your data model or a synthetic dimension using ValueList('current','YTD'), then check this dimension's current value in your expression and branch into current / YTD evaluation:
=If( ValueList('current','YTD') = 'current',
YouCurrentExpressions,
YourYTDExpressions
)
Hi Gysbert,
Normally the label of expression will be like current actual, YTD actual, current forecast, YTD forecast, etc. If I can categorize them as the header of the example, it will be clearer for user, right? Or do you have any other suggestion?
Hi Stefan,
It is not about synthetic dimension. Dimension should be fixed, just the expressions should be put into different category as my example, like what we will do in Excel. You may refer to my reply to Gysbert. Or if you can provide an example it will be better, if my understanding is not accurate.
A chart doesn't have Categories, only Dimensions and Expressions. Therefore if you want to create categories you need to create a dimension. A synthetic dimension like swuehl posted above will do the trick.
ok, I will try . Thank you all for the help!