Discussion board where members can get started with QlikView.
Hi i have a pivot table in the fields have
count of report names
these are the dimensions and expressions, count will shows based on each month
in normal view it will shows the total count based on all months for the particular report. when i do cross table it will shows only the count will be in based on month not the total month count
it is showing only individual month count when i do cross table it is not showing total months count.
But in normal mode it is showing total month count.
Hi Manoj. Can you show the expression?
i done month table as cross table so it will show the count based on month its fine but i want total count as well.
Sorry, it seems I do not understand what you are trying to achieve. Maybe you can share a sample
Did you try checking show partial sums for Month field in your presentation tab of pivot table chart?
Hope This video will help you.