Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
As shown in below image, in pivote table, whenever we apply partial sum , label Total gets displayed
My Req. is it should show, that particular dimension value & ' Total' .
like below image:
Is it possible ???
Thanks in advance . . .
Regards,
Prasad D. Dumbre
unfortunately this cannot be done in QlikView so far
Hi This may help you
but in this case all Total labels will be Total Services URL's
This was just an example...You can have name you want
Maybe your problem is that you have unchecked the property "Allow Pivoting".
check this and try again.
Hello,
You can only go for modifying your data and adding a total line in the script I suppose.
BR
Serhan
Hi Prasad,
it would seem that a solution is yet to be found regarding this requirement.
Here's a bit of workaround to your problem:
Label for Totals Expressions in Pivot Table
this thread has made use of Indent Mode
Hello Prasad,
I made a similar thing to calculate total for region and country.
You need to add in Amount dimension some different values for new different total and every single total need to join each value of Amount.
For example, you have Amount 200, 300, 400 and you want USD Total, EUR Total and so on...
You need to create a new dimension TotalAmount where you have a link for
USD Total to 200, 300, 400
EUR Total to 200, 300, 400
....
More all single Amount value, so
200
300
400
....
in your table you put the new dimension TotalAmount
I hope this help you.
Regards
Luca Jonathan Panetta
Check this