Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I am facing a problem to find the difference or varience between two values of same dimension.
My application data is this:
Note: Here FYQ means Quarter.
First I want Quarter Report which I get by using this data.
Now I want a table that shows the difference of FYQ-2 and FYQ-1 and so on.
Means if I select FYQ-x and FYQ-y in the Dimension then It shows me the difference FYQ-(y-x).
Thanks
SG
Could you please share the sample file or the dimensions and expression you have wrote
I want to select two-quarter FYQ-1 and FYQ-1 and each quarter has 3 months. In measures I use set analysis that subtract the value of fyq-2 to fyq-1 but that is not automated I want that in future if I select fyq-3 and fyq-2 them it automatically subtract fyq-3 to fyq-2 and so on.
thats is my problem what should I add in dimension right now the there is no dimension it is "Getcurrentselection()"