Forum Discussion

harirao's avatar
harirao
Post Prodigy
5 years ago
Solved

Unable to add Calculated Measures under Rows in Matrix Table

Hi All,

 

Can you please assist me on the below, I have created calculated measures, but unable to include same under Rows in Matrix table

Need to created visualization as per below snapshot

 

Thanks for your help

 

Regards,

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi harirao 

    I think you want to show column header "No.of Deals", ">6 weeks visibility"... to show in Rows like the screenshot you show.

    Now your visual shows like mine as below.

    You can try "Show on rows" option in value in format.

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi harirao 

    I think you want to show column header "No.of Deals", ">6 weeks visibility"... to show in Rows like the screenshot you show.

    Now your visual shows like mine as below.

    You can try "Show on rows" option in value in format.

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi harirao ,

     

    Are you trying to move a calculated MEASURE to the "Rows" section under Matrix visual?

    If yes, then it won't work because measure gives you a single value.

    "Rows" section accepts only COLUMN fields with multiple values. So, you may need to convert your MEASURE calculation to a COLUMN caluclation if you want to use it.

     

    Thanks,

    Pragati