I have a pivot table in which i want to display the Totals with a different calculations for different columns. I am using the Totals option in the pivot table to display the "Totals".
The calculation of the Totals should not be a regular sum of net_val for each fund instead it should be a based on a different formula for different column. Currently , "Total" shows the sum of net_val for underlining funds. But i expect the "Total" have a different calculation. It should be the sum (net_val*Val ) of each fund for column ABC and sum(net_val/Val ) for column DEF.
Thanks for replying. I have attached the qvf again where you will be able to see ABC and DEF columns.
I am not sure where can i put this Dimensionality() function since there is no way i can change the functionality of Totals (provided by Qlik Sense) or should i put it in the Dimension where we are calculating the Totals?
ABC and DEF are different columns . I want the Totals for be calculated differently for different columns in the pivot table.
At the moment, the Totals is the aggregation of the underline rows. (funds in my example)
Dimensionality() works only for rows in a pivot table ?
Also, i would like to mention that i am using Qlik Sense Apr 2019 version.