Grand Totals in Straight Table

[sridhar1]

Hi All,

I have issue with grand totals when looking at particular order number. Below is the scenario

Sales Person	Order Number	Sales $$	Total Sales $$ by Order
ABC	123	200	500
XYZ	123	300	500
QWE	456	100	100
WER	234	250	250
Grand Total		850	1350

Sales $$ Grand Total is looking good but Total Sales $$ by Order is adding all the numbers which is wrong it should show 850$ as well.

And we have filter to one order 123 Grand Total is showing up 1000$ which is it should show only $500.

How do I achieve this?

Thanks

Sridhar

[sunny_talwar]

Sorry, but may be somebody else might be able to help. Read what you wrote 2-3 times, but still not sure I understood.

[NZFei]

That is easy!

Fei

[sridhar1]

Hey Fei,

What is Totals Function you used.

[NZFei · Accepted solution]

If you don't know this function, you really need to search and learn it. We use it a lot.

It is used in chart and ignore the dimensions.

In above example, if you use sum(total [Sales $$]), you will have 850 for all the rows because it ignore all the dimensions.

If you use sum(total <[Order Number]> [Sales $$]), you ignore all the dimensions except [Order Number]. So the result is the total sales by order numbers.

Have a play and you will understand it

Fei

[sridhar1]

I am New to Qlik Tool and Yep I agree need to learn a lot.

Thanks for your help and suggestions.

[NZFei]

No worries. Glad that I can help. Welcome to the Qlik world