Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Choose 2 categories and compare

Hi,

 

In a matrix I want to compare the values of 2 supermarkets with each other and calculate the difference.

I found a work-around where I show the value of the minimum supermarket and the maximum supermarket and compare these values.

 

Actually, I don't really like that. Is there another way?

 

It should be something like this:

Need Help

4 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

     

    I'm afraid the solutions could be similar. Because you want to "choose" 2 categories. We can't hardcode only two categories. What could be the result you expect?

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi v-jiascu-msft,

       

      In Tableau you can make parameters and use them as a filter. Something like that would at least work.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi Anonymous,

         

        I read this post again and found your desired result could be a normal request. Can you share a dummy sample please? That would be easy for us to communicate. The solution could be creating several measures. If you select stores in a slicer, the measures will recalculate automatically.

         

        Best Regards,

        Dale