Forum Discussion
jvahlund
Oct 04, 2021Copper Contributor
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...
jvahlund
Oct 05, 2021Copper Contributor
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
Oct 05, 2021Diamond Contributor
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.