11 Replies Latest reply: Jul 29, 2016 2:29 PM by Buck Master

# Pivot calculations

We have 3 customers showing in the table. we want to show each customers sales in a column, then a total column for those customers.

We another column to show the 3 remaining customer totals and the last column needs to be a total of all customers.

Any help would be great...

Thanks

• ###### Re: Pivot calculations

What would be the required output, can you provide that in an Excel file?

• ###### Re: Pivot calculations

I guess I don't understand what is Customer A, Customer B, Customer C.

You measures are just some variation of Sum(SalesAmount). Is this just a sample?

• ###### Re: Pivot calculations

This?

• ###### Re: Pivot calculations

Yes just a sample

• ###### Re: Pivot calculations

Does the attached sample meets your requirement?

• ###### Re: Pivot calculations

Sorry i don't see your Corrected App. Did you attach it?

• ###### Re: Pivot calculations

Thank you that is perfect

• ###### Re: Pivot calculations

If not, please make clear what part of this topic you still need help with .

• ###### Re: Pivot calculations

Sure but i can't find where that button is to pick it.

• ###### Re: Pivot calculations

How does this work?

With 6  customers in this sample,

1) What does the dim  inline load actually do?

2) How does it know what to sum?

You built A pick column statement where dim values are 1 through 4,

You have 4 sum statements within each measure, two are the same, the third is the same accept for "-=" and the last sum for all. ?????

My brain is hurting, help me OB1!