Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a master calendar and setup some variable which prepared for using point in time reporting
PeriodID = {$(=Max(PeriodID) – 12)}, Year = , Quarter = , Month = , Period =
QuarterID = {$(=Max(QuarterID) – 4)}, Year = , Quarter = , Month = , Period =
It works when I use it in measure, like below:
=Sum(${<=$(vSetPreviousQuarter)>} [SALES_USD])
However, I want to use the variable in chart as dimension.
In other words, is it possible to make
Current YTD vs LY YTD in the x-axis of a bar chart?
you can fill nothing in dimension and leave the expressions with these values!
if not the expressions in dimension without aggr , I don't see very well
sorry, so how can i create a dimension
Current YTD vs LY YTD?
can you share a sample data ?