Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
attached is a reduced document for the sake of big size with one pivot table
the expression has one value of 7 but the paritial sum is not showing
please help
I changed the else part in the expression from null() to 0 and chart to straight table. I can see the subtotal in straight table if I select expression total as sum of rows. So I think it can be done only at script level if you need a pivot chart.
Regards,
Kiran.