6 Replies Latest reply on Sep 18, 2014 8:07 PM by Basavareddy patil

# Calculating on aggregation column from granular level

Hi,

There are 2 spreadsheets i have attached product data.xls and product cost.xls.

I have requirement to calculate Current value Vs Desired value  at Product Level.

Logic -

Step1 - Cal1 = Calculate current value vs Desired value(Current value/Desired value) at application level

step2 - Cal2 = Cal1 * Prodcut cost.cost (From prodcut cost.xls. Cost of each application)

step3 - Cal3 = SUM(Cal2)/SUM(Prodcut cost.cost) (at product level)

Final Result should be as below

Product Cal3

P1         0.79

P2          0.80

• ###### 1. Re: Calculating on aggregation column from granular level

I missd out the attachment.

• ###### 2. Re: Calculating on aggregation column from granular level

Can someone please provide me the solution.

Basava

• ###### 3. Re: Calculating on aggregation column from granular level

Hi,

Check the calculations, Let me know if need any additional Calculation part.

https://public.tableausoftware.com/views/Calculations_SampleDataSources/Sheet1?:embed=y&:display_count=no

Thanks

Laxman Kumar

• ###### 4. Re: Calculating on aggregation column from granular level

Hi Laxman,

Final output should not have application. The data should be at Product level.

Thanks

Basava

• ###### 5. Re: Calculating on aggregation column from granular level

Hi,

I modified the calculation & check it, itf that does not meet your requirement ,Explian How you are expecting that value with Sample calculations.

Thanks

Laxman Kumar

• ###### 6. Re: Calculating on aggregation column from granular level

Hi Kumar,

I have did the sample calculation in spreadsheet attached. please go through it and let me know you if you have any further queries.

Thanks

Basava