How to summarize and show expression totals in Pivot table

[Ankhi]

Hi All,

I have to create a pivot table like below. I have 8 expressions and 3 dimensions.  A sample  requirement is below.

I have created the NSC and TSC part , but I have to create a summary part as well. 

So in the summary for Programme A the YTD should TSC-A + NSC-A(100+200=300),

similarly for B it should be TSC-B + NSC-B.(500 + 100=600). 

Is this possible ? Please can any one help?

Category	Programme	Manager	YTD
TSC	A	X	100
	B	X	500
TSC-Total			600
NSC	A	X	200
	B	X	100
NSC-Total			300
Summary	A	X	300
	B	X	600
Summary Total			900

Regards

Ankhi

[Saravanan_Desingh]

Try this.

tab1:
LOAD * INLINE [
    Category, Programme, Manager, YTD
    TSC, A, X, 100
    TSC, B, X, 500
    NSC, A, X, 200
    NSC, B, X, 100
];

Dim:
LOAD * INLINE [
    Dim
    1
    2
];

Dimension:

=If(Dim=1,Category,'Summary')

Programme

Expression: Sum(YTD)

[Saravanan_Desingh]

Output:

[Lisa_P]

Using QlikView expand Category, go to chart properties, Presentation and for both Category and Programme, select Show Partial Sums.

[Ankhi]

Thanks Lisa for the reply. I have done that. But I want a summary section which along with Grand Total will show total for each dimension value as given in my table (summary section)  in my 1st post.

[Ankhi]

Hi Saran, 

Thanks for your reply. But I don't think  I am getting you. Below is the actual dimensions that I am using

=if([Category]='Labour','TSC','NSC')--->This is the Category

Programme

Programme Manager

Expressions: I have got 8 expression like below. Just given 1 for e.g.

YTD=Sum({<
[Flag]={'ACT'},
[F_DATE] = {"<=$(=max(F_DATE))"},
>}Cost)

Below bold rows are what  I need. 

Expenditure Category	Programme	Programme Manager	ITD Actuals
Summary Total			1000
TSC	Total		300
TSC	A	X	100
TSC	B	X	200
NSC	Total		700
NSC	A	X	300
NSC	B	X	400
Summary Total			1000
Summary	A	X	400
Summary	B	X	600

Regards

Ankhi

[Brett_Bleess]

Would likely be most helpful for you to attach the QVW to the thread if you want further assistance, as I think folks are likely still confused as to what exactly you are trying to do.  This way they will have access to the data model as well as the sheet objects and properties to check everything.

Regards,
Brett