Pivot calculations

[deerhunter]

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

[deerhunter]

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!

[deerhunter]

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