Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Probably a simple question.
The below excel example show what I want to do.
All CostComponentFrom has the same value. I only want this single value to be summed when I collapse the dimensions in the pivot table.
Hi,
Might be it is your solution
See the attached sample file Hope this may be help you.
Let me know about this.
Rgds
Anand
Here is the excel sheet showing what I am trying to do.
Hi,
You have to use Sum(Distinct Value) to show that value you are asking for like
132 + 78 = 210
And use pivot table to show this type of data representation.
Rgds
Anand
Hi,
Might be it is your solution
See the attached sample file Hope this may be help you.
Let me know about this.
Rgds
Anand