Discussion board where members can get started with QlikView.
I was wondering if I could get some help please.
I have a list of sales team members and their sales in a pivot table. I would like to show the subtotal for each sales team as well as the grand total. Please see example below of current data set and what I would like to achieve.
Please try Pivot table where should be selected option "show partial sum" per each dimension on the presentation tab.
Hope it will help you.
It worked, thank you so much for your quick response.
Have a great evening!
You may want to read Qlik Community Tip: Marking Replies as Correct or Helpful
Refer to the attached sample using Valuelist method (synthetic dimension)