Contribution AutoCalculation in PVT

[Istiyak]

Hi Team,

I have one queary. Unable to creat Calculated Field in PVT which content Contribution of Each Category.

Product Figures devided by TTL Grand Figures.

Attaching File for the same.

Regards
Istiyak

 

[Somendra Misra]

Hi Istiyak,

Please see the attached file, is this what you want?

Regards!

 

[Istiyak]

Got What i needed.

Still one confusion. Why two calculated fields are there?

I Have to do the same by my self but it is not happening.?

Regards
Istiyak

 

[Somendra Misra]

@Istiyak,

Actually first one was trial, I didn't removed it. The one which is visible is the required I suppose.
For doing the same
Step 1: Go to calculated field.
Step 2: Name you field "Contribution %" and add formula = Ash
Step 3: Select any cell of this field rht click show values as %of Grand Total

Thats it! Its done

Regards!

 

[Xiq]

@Somendra Misra

You dont have to add a field, simply use the normal Ash-field. You can place multiple values based on the same field. If you don't like the name, you can edit these via "Value Field Setting".

 

[Istiyak]

Amazing....

Thanks for Step By Step Istructions... Thanking for promp response.

Regards
Istiyak

 

[Istiyak]

@Xiq

I have tried the same.

 

[Somendra Misra]

@Xiq

OP wants to show values as well as %. Pardon me if I don't got your Idea.

@Istiyak
Glad you solve it.

Regards!

 

[Xiq]

@Somendra Misra
You use "calculated field"-method and I don't, but the end result is the same.

Here is the method I used:

1. Place the field "MC Name" in the "Row Labels"-box
2. Place the field "Ach" in the "Values"-box
3. Select any cell of this field right click show values as %of Grand Total
   
4. Repeat step 2
5. ...
6. Profit!

 

[Somendra Misra]

@Xiq

Gr8 method....Thanks for this knowledge.

Regards!