Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Is it possible to have a dynamic Totals colum in a pivot table?
In this example I have the sales for two companies and a Totals colum.
Sales | |||
Product | Totals | Company A | Company B |
A | 10 | 5 | 5 |
B | 20 | 10 | 10 |
C | 30 | 15 | 15 |
If I only select one company I don't want to show the Totals colum as I will have two colums with the same data.
Sales | |
Product | Company A |
A | 5 |
B | 10 |
C | 15 |
Thanks
Andreas
Hi Marcus
Thanks! It works as intended with this expression:
/Andreas
You may try it with an extended expression, like:
if(count(distinct Company) = 1 and secondarydimensionality() = 0, null(), YourExpression)
- Marcus
Hi Marcus
Thanks! It works as intended with this expression:
/Andreas