Forum Discussion
Matrix columns subtotal in Matrix
Hi, I'm struggling now for a long time to add subtotals tot my matrix based on different columns. I have three columns: FTE : Average personnel per month Cost: Amount of Personnel costs pe...
guys for trying to help.
But luckily I were managed to do it by myself.
I used the DAX formula =HASONEFILTER
Formula: Measure =
[FTE SumX] + SUM('Appendtable CTC'[Amount]) -
IF(HASONEFILTER('GL Account Group'[Actual]),SUMX(SUMMARIZE(FTE,FTE[Employee],"Average1",FTE[FTE total]),[Average1]),[FTE SumX])With this HASONEFILTER in the matrix under FTE shows the right FTE hours and under total i don't sum up the FTE but only the Cost Recovery.
Anonymous
I am not following. Could you show us what does your matrix look like along with the xpected results?
thannks