I am trying to build a pivot chart in QV that gives me the % of the total column. Right now I have two deminsions present Yr and Month.
Here is an example of what I am trying to do. I need to fill in the % of Deals column. (in July I would expect to see 50% for New and 50% for Upgrade)
|New / Upgrade||# of Deals||% of Deals||# of Deals||% of Deals||# of Deals||% of Deals||# of Deals||% of Deals||# of Deals||% of Deals||# of Deals||% of Deals|
Any help that could be provided would be great.
Something like this should do the trick:
Stephen Redmond is author of QlikView for Developer's Cookbook
Follow me on Twitter: @stephencredmond