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.
Something like this??
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??
Hi,
Thanks for your reply, im not sure i get what you mean though?
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',.....)>}
can you send me the qvw, so i can have a look
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,
Something like this??