Forum Discussion

Pillsbury33's avatar
Pillsbury33
Icon for Helper I rankHelper I
6 years ago

How to slice across two tables

Hello everyone,   I’ve looked at a number of threads but can’t anything to help with this. I am trying to divide two columns from different tables and create a new measure. I have tried 100 differe...
Need Help
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Pillsbury33 

 

Use the Site Name not UserSite

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

  • Pillsbury33's avatar
    Pillsbury33
    Icon for Helper I rankHelper I
    6 years ago

    Hello Mariusz

     

    Thanks for the response. As below, I have done this but it still doesn't help with the slicer i.e. the visual ignores the slicer selection for the denominator and divides by the whole number but the slicer still recognises the numerator i.e. 300 site A ZPs / 12,000 total FTE rather than 300 site A ZPs / 456 site A FTEs.

     

    Thanks, Pillsbury33.