Hi Mynda,
Thanks for the work has done so far. I am wonder if you could help me how to write DAX in below case.
As per attachment, I would like to calculate the Monthly salary or other cost /total cost by branch and month,
So in Apr, WA/SA/NT branch, Monthly salary/total cost in WA/SA/NT=73%, other cost/total cost in WA/SA/NT=37%
thanks in advance.
Hi Vivian,
There's no attachment. Please try uploading it again.
Thanks,
Mynda
as attached, the % wanna to show is listed and wanna a pie chart out of it.thanks
Hi Vivian,
Right-click the values area of the PivotTable > Show Values as > % of parent row total. Obviously you can't create a Pie Chart from the PivotTable when it contains all branches, you'd have to create a single PivotTable for each branch that will support the individual Pie Charts.
Mynda
Mynda
