Discussion board where members can get started with QlikView.
Hi, I have created a pivot table with 2 dimensions, Province and month. Would like to create a total for the 3 months but it needs to show next to March. I have attached an example. Please assist. Thanks Kalpana
Enable the Show Partial Sums option on the Presentation tab for the Province dimension. Use the Subtotals on Top or Subtotals at Bottom to show the totals where you want them.
Thanks but I need to see the total values for the months at the end. Jan + Feb + Mar = Total.
Use the Subtotals on Top or Subtotals at Bottom to show the totals where you want them.