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

HI Shiv,

I solved ur req with  and without LOD.

Check the attachment and let me know if it satisfies.

Thanks

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

Thanks Venkata. This looks great and working. Just to ask you more and solution without LOD, I have cleared the table calculation that you added on the amount. I tried adding sub total and Column grand totals but I am getting this though the metric is in the continuous mode.

Any thoughts on this?

Thanks and Regards,

Ashish Chaudhari

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

Thanks Venkata. As I am using Tableau 8.2, your workbook doesn't open up.

Could you please tell me the steps or screenshots of how you achieved this?

Kind Regards,

Shivang Desai

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

Hi Shivang,

1. Calc_Bvg_OrderId

(IF [Cateogry]="Beverages"  then [Order]

END)

2. Calc_Amount

if ATTR([Calc_Bvg_OrderId])=ATTR([Order]) then (SUM([Amount]))

END

3. Calculation1

if [Cateogry]='Beverages' then 0 else 1 END

4. Calculation2

PREVIOUS_VALUE(1)*SUM([Calculation1])

Create the above calculations.

add calculation2 to the filter and set it to 0.

double click and amount and add a table calculation on it like this.

You will get the following result. i have asked some more details on the same to Venkata.

Thanks and Regards,

Ashish Chaudhari

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

shivang ,

you can use my formula also to do it.

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

where did you use calc_amnt ?

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

Not used anywhere. Ignore it.

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

Gives true for everything that doesn't have sales order number as beverages...

see below:

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

It gives me the sales for items whose order number is not same as beverages

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

shivang ,

you have to apply table calculation on cell level.

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

Hi,

Did it but after that nothing happens.

See below:

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

It doesn't show the correct results on my workbook!

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

Can you share the 8.2 workbook?  I have that installed.  Looks like others jumped in, but let me know if you need some help.

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

Hi,

I achieved this till now! It gives me all products having sales order number as beverages in it. Now how can I get the total of all those in calculation.

see screenshot below:

I want 14.27+ 7.18+1.36+... total at the bottom

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

Hi,

Go to analysis tab and select show total for columns.

1 of 1 people found this helpful
1 2 3