Issue with parital sums

[#1]

Dear All,

I'm using a pivot table in which i have divided the results of my expressions into three parts by dimensions as follows;

Through dimensionality, i've managed to remove the unit price totals. I need all other totals apart from those circled in green.

Is there a way by which i can remove the totals circled in green but keep those circled in red.

Also is there any other way to calculate a total apart from clicking the partial sums checkbox in the presentation tab.

thanks.

[#2]

Why you want totals for januari? and not the other months? If so, use the same dimensionality() function with an IF (month='jan') statement for month??

[#3]

Hi,

Thanks for your reply, im not sure i get what you mean though?

[sunil2288]

Hi MSa,

If you does want the total of Only for the month of january Then you should put condition in the expression

As

{<$(Month)-={'January',.....)>}

[#5]

can you send me the qvw, so i can have a look

[#6]

Hi,

I couldn't attach the qvw so i posted it here;

http://community.qlik.com/members/msadrikhcb/files/sample.qvw.aspx

Hi Sunil, thanks for your reply but that does not give me exactly what i want.

regards,

[#7 · Accepted solution]

Something like this??