Subtotals in Pivot table chart and hiding column from chart but maintaining the sort based on field
Good afternoon All,
I am trying to get a Chart in Qlikview that look like this output below. I have attached the qvw with the data. I have a sorting field call "Sorting" that gets the data in the order that I want but I don't want the field to be displayed but want the sort to happen based on that field. Also I am wanting subtotals at "SL_Account_Group", when I do this under presentation tab and check show partial sums, it creates the subtotal after every SL_Bgt_Acct_No. You can see it in the qvw, can someone help me solve my issue?
S.T or anyone else , I have a second table now that I want to combine current fiscal year actuals( 1st 7 fiscal periods) and remaining periods as bgt (periods 8-12). Also the totals and %'s and difference columns out to the right. What I want the output to look like is in the paste below. Attached is the qvw with the details. If anyone could help it would be much appreciated.