Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I got two questions:
1) What is the best way to figure out how to understand Set Analysis syntax? I have used the Help and Wizard and they have been difficult to understand especially since I have applied the examples and don't necessarily get what it says. Especially in a drill down situation.
2) How do you get the previous value using set analysis for drill down on a Pivot or Table Chart?
Using the Trial and Error approach to figure out the syntax to this Set Analysis and just can't make this code work or anycode work for that matter.
I am using ABOVE or BELOW, but it isnt the same and doesnt drill down well because it doesnt accomdate for the level up.
I have been trying to bring the values of the previous value to compare against and create a variance in this situation below. I have 10 cycles in a month and days in each cycle which I want to compare against. So I would love to be able to see
Cycle 1 vs Cycle 2 and then drill down and get Cycle 1 Month 1 Day1 vs Cycle 2 Month 2 Day 1 and so on.
Here are some of the codes I tried to figure this one out:
Sum({<[CYCLE]={$(#=(Cycle)-1)}>}Cycle_COUNT)
Sum({<[CYCLE_DATE]={$(=(Cycle_DATE)-1)}>}Cycle_COUNT)
Sum({<[CYCLE_DATE]={$(=(vCDATE)-1)}>}Cycle_COUNT) - Variable Version ( Where gets current selection date)
Row Labels | Sum of Counts1 | Sum of Counts2 | Sum of Amount1 | Sum of Amount2 | Previous Value Amt1 |
1 | 30 | 30 | 2650 | 1600 | |
1/1/2012 | 1 | 4 | 100 | 100 | --- |
1/2/2012 | 2 | 3 | 150 | 100 | --- |
1/3/2012 | 3 | 2 | 200 | 200 | --- |
1/4/2012 | 4 | 1 | 100 | 100 | --- |
2/1/2012 | 1 | 4 | 200 | 200 | 100 |
2/2/2012 | 2 | 3 | 250 | 100 | 150 |
2/3/2012 | 3 | 2 | 300 | 200 | 200 |
2/4/2012 | 4 | 1 | 200 | 100 | 100 |
3/1/2012 | 1 | 4 | 300 | 100 | 200 |
3/2/2012 | 2 | 3 | 350 | 100 | 250 |
3/3/2012 | 3 | 2 | 300 | 200 | 300 |
3/4/2012 | 4 | 1 | 200 | 100 | 200 |
2 | 30 | 30 | 1800 | 2300 | 2650 |
Thanks for your help.
I think this is a case that would be better to do in the load script creating a table with that values already calculated because inter-register functions work only over rows and columns