Forum Discussion
Calculated item alternative
Hi,
Do not drag Sex to the column area section. Just drag years to the row area section and then write the 3 measures that i shared with you in my earlier post.
Hi,
v-piga-msft has already shared that solution with you.
Asish, v-piga-msft solution was for an unpivotted file with columns for male and female!
Hi,
In which case, i am not clear about the terminology you are using. Please show the dataset and the expected result.
Ashish, on the left is is my data set in the data tab view, on the right I have choosen a matrix (left hand) adn some other visuals.
I cannot calculate the sex ratio measure in report tab based on the columns Female and male with the solution provided.
Sorry about the confusion, I hope now it is clear.
Data set in Data tab viewMatrix table in Report view
Hi,
Do not drag Sex to the column area section. Just drag years to the row area section and then write the 3 measures that i shared with you in my earlier post.