Forum Discussion

jvahlund's avatar
jvahlund
Copper Contributor
Oct 04, 2021

Excel pivot calculated field

Hello, I have a problem which I dont know how to solve.   In my pivot, I have added a column named "Weighted Total %" based on the column next to it called "Weighted Totals". This percentage repres...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 04, 2021

jvahlund 

That could be done with data model measure (if only you are not on Mac). Creating PivotTable add data to data model, for such sample

add DAX measure as

BB:=VAR grandTotal=CALCULATE( SUM(Table1[B]), ALL(Table1) ) RETURN DIVIDE(SUM(Table1[B]), grandTotal, 0)*389060

and use it in PivotTable.

jvahlund's avatar
jvahlund
Copper Contributor
Oct 05, 2021

SergeiBaklan 

 

Thank you so much for your reply. I actually came around this issue with another solution (in my SQL statement.) But I really appreciate your time and effort in replying to this.

 

I'll have that in mind until the next time 🙂 

 

Cheers!

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 05, 2021

    jvahlund , you are welcome, thank you for the feedback.

    In general creating PivotTable it's always better to work with data model, you have much more power compare to PivotCache PivotTable.

Resources