Forum Discussion

RonLieuw's avatar
RonLieuw
Helper I
8 years ago
Solved

Calculated item alternative

  I need to calculate a Sex ratio ([male/female]*100) for every year. I read on the forum to make 3 measure e.g F, M and use sexratio=M/F. I am having problems calculating the measures F and M, wh...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

In which case, i am not clear about the terminology you are using.  Please show the dataset and the expected result.

RonLieuw's avatar
RonLieuw
Helper I
8 years ago

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    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.

  • RonLieuw's avatar
    RonLieuw
    Helper I
    8 years ago

    Ashish, you the Men. That's the solution I was looking for. Thanks

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    You are welcome.