3 Replies Latest reply on Jul 25, 2018 5:01 AM by Mahfooj Khan

# Find Calculation based Columns from Attached data

Hi,

As per attached, I have columns from B to G.

I want to derive columns H, I and J which are calculations given at the top of Header. You can find the formula mentioned above header.

I have also given the Expected Result that i am looking for which is a summary level for %Tickts and Extra Spend columns (Coloured in Red)

The challenge in this is that i have to calculate Columns H(Avg fare),I(Diff in fare) and J(Exra Spend) based on Bookings columns i.e.Offline and Online.

eg : if Offline value is 5846 and Online value is 5750 it should calculate based on Travel Route individually. In my case the values are 96,1000,etc.

I tried using Table Calculation but not able to Summarize the data as we can't Aggregate the field that has Table Calculation.

Can someone let me know the solution for the same.

Thanks,

Vijay.

• ###### 2. Re: Find Calculation based Columns from Attached data

Hi Vijay,

Is that what you wanted?

Workbook attached for your reference. Let us know if this help.

Note: Kindly check your % Ticket calculation once again.

Mahfooj

1 of 1 people found this helpful
• ###### 3. Re: Find Calculation based Columns from Attached data

Did it work? If yes then you can close the thread by marking my answer as correct so that its get hide from unanswered list and others can refer this thread who have similar question.

Else let us know if you still have some doubt.