Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Is there anyway to create a "double" pivot table like below?
| Current Month | Consolidated | US | |||||
| Actual | Budget | % A vs B | Actual | Budget | % A vs B | ||
| Widget Count | |||||||
| Widget $ | |||||||
| Widget ASP | |||||||
Why not? Have you tried?
Peter
Yes...kind of. You can't do it directly, but you can with a workaround. You need to create a dimension with values Consolidated and US and add that to the chart. The easiest way to create the dimension is to us the ValueList() function. Add ValueList('Consolidated', 'US') as the last dimension in your chart and then drag it across the top.
You can reference the dimension in an expression by saying If(ValueList('Consolidated', 'US') = 'US', 1, 0). That allows different expressions for each dimension, but unfortunately, the expression titles must be the same.
There is also a more complicated way that allows for different expressions between the dimensions, but it is more work.