1 2 3 Previous Next 38 Replies Latest reply on Apr 28, 2016 10:33 PM by Shivang Desai Go to original post
• ###### 30. Re: Getting total sales in tableau for all order numbers that have order number same as beverages

Hi Tharashashank,,

I used your formula but the change I made is "Compute using Product Class (in the sample workbook Product class is Category)" and applied everything at cell level.

Now I just need total of all amount at the bottom , how can this be achieved?

• ###### 31. Re: Getting total sales in tableau for all order numbers that have order number same as beverages

Hi,

Go to analysis and select grand totals.

1 of 1 people found this helpful
• ###### 32. Re: Getting total sales in tableau for all order numbers that have order number same as beverages

Thanks a lot!

Will perform some testing and let you know.

• ###### 33. Re: Getting total sales in tableau for all order numbers that have order number same as beverages

Hi Shivang Desai,

If my calculation worked for you mark that as correct answer.

• ###### 34. Re: Getting total sales in tableau for all order numbers that have order number same as beverages

Yeah will test it now on live data and mark. Thanks!

• ###### 35. Re: Getting total sales in tableau for all order numbers that have order number same as beverages

Hi,

This gives me the total sales for all orders which doesn't have sales order as beverages but the data seems fine!

Why so?

Example:

the above gives me 19484 as total which should actually be 13848 if we sum the above.

• ###### 36. Re: Getting total sales in tableau for all order numbers that have order number same as beverages

Hi ,

How are you calculating grand total of that column.

• ###### 37. Re: Getting total sales in tableau for all order numbers that have order number same as beverages

Hi,

using sum nett in label field and then see below screenshot:

• ###### 38. Re: Getting total sales in tableau for all order numbers that have order number same as beverages

Also is there a way where I don't use product class in columns and still get the sales for that particular id using your technique? I tried to remove product column and the workbook goes blank...

1 2 3 Previous Next