Discussion board where members can get started with QlikView.
i want to achieve the grand total column for both last row and last column as grand total
i have attached sample and result
can anyone help me on this??
This is very vague
i want to show grand total for last row and last column in qlikview pivot table
What is the issue you are facing?? isn't turning on the partial sum for product and Quarter not working???
look at the attach example isn't it what you are looking for
exactly.. what you have done? i cant find the changes?
lironbaram can you explain me how it done?
how you got last column as total ?
you just need to tick on the 'show partial sum' for the Quarter.
but if i have multiple measures im getting multiple rows for total.
attached you can see
remove the 'Partial sum' for field 'Type'.