Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, I think I already know the answer but I thought I would ask. I am using a pivot table to show by customer, sales order and service the total dollar value,
number ordered. I want to show the total dollar value, but not the total number ordered because it makes no since. Is there a way to suppress the total for number ordered and still have a total dollar value of the sales order? From reading the different posts I think I'm out of luck.
Thanks
I assume you are talking about the totals that show when using 'partial sums'?
How about rather than using the expression:
sum([number ordered])
you use instead:
if (rowno() <> 0, sum([number ordered])
where in this context rowno() returns the row number in the current column segment and so is 0 when its a total line.
If you have partial sums at the lowest dimension level (ie you have a 'grand total' line) and you want to suppress that too use instead:
if (rowno() <> 0 and rowno(TOTAL) <> 0, sum([number ordered])
Regards,
Gordon
I assume you are talking about the totals that show when using 'partial sums'?
How about rather than using the expression:
sum([number ordered])
you use instead:
if (rowno() <> 0, sum([number ordered])
where in this context rowno() returns the row number in the current column segment and so is 0 when its a total line.
If you have partial sums at the lowest dimension level (ie you have a 'grand total' line) and you want to suppress that too use instead:
if (rowno() <> 0 and rowno(TOTAL) <> 0, sum([number ordered])
Regards,
Gordon
Thanks Gordon. This exactly what I wanted to do.....I know anything is possible with QlikView, you just need to find out how to do it.