Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I have a Pivot table that gets the information from 3 different tables; Sales, WP, RFC.
The Pivot holds 3 fields; Qty, Value, Avg P.
Instead of writing 9 expressions I made a dimension ('Source') that holds Sales,WP & RFC as values.
This way I wrote only 3 expressions with if statements and used the 'Source' as a dimension.
So now I have a nice looking pivot, the problem is, I need additional data that doesn't belong to the Source dimension.
For example, I need the delta between LY and RFC.
Any thoughts about how I can accomplish that ?
Regards,
Eliran.
There are a bunch of different ways to apprach this. Without knowing all the details, I would try the simplest thing. You can refer to the other columns in a pivot by their expression label, just like script variables.