Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
Hope someone could help me on this...
I have a rangesum formula from a different pivot table...
RangeSum(alt(Before(TOTAL [Gross Forecast]), 0), sum({$<Term = {'Supply'}>} Qty) - sum({$<Term= {'Demand'}>} Qty)) with field label [Gross Forecast]
Now I'd like to create a new pivot table and create an expression value to get the value from the other pivot table and multiply by 50%
I tried using [Gross Forecast] *.5 but doesn't work
I also tried using 2 expressions
where 1st ex label as Forecast
RangeSum(alt(Before(TOTAL [Gross Forecast]), 0), sum({$<Term = {'Supply'}>} Qty) - sum({$<Term= {'Demand'}>} Qty)) with field label [Forecast]
and 2nd expression as Forecast *.5 but still doesn't work.
Is there any way to do it?
Pls. advise.
Tks
You can't access the expression values of one table from within another table.
You would need to replicate the expression values in the second table, if the dimensions of both tables differ, you can use advanced aggregation to create a 'virtual table':