Discussion Board for collaboration related to QlikView App Development.
Say I have a data structure that looks like:
Load * Inline
And I have a pivot table with dimensions Client and Spend and expression Sum(Receive). At the bottom of the chart I want to show a total for Spend. Is this possible? And, if so, how can I do it?
I've attached an example to help illustrate my question.
Thanks and best,
As per as I know it is difficult to do that.
I tried different approach by taking two objects. Have a look and see if you can do the same.
(1) Pivot table for showing data
(2) Straight table to show the total at bottom.
Basically you need cover bottom report with top by using layout --> Layer
sory, but my license ended
Do you expect 33 or rather 66 as sum of Spend?
No ideal ....
It is also possible to have it in 'Spend' Label field.
But to have it under Spend dimension column, i think only chiru.thota solution will work
Unfortunetely it may be difficult if your user would like to resize or move pivot ....