4 Replies Latest reply on Sep 30, 2013 4:30 AM by Robert Sutter

    filter combined dimensions

    Marc Roest

      Hi,

       

      I'm new to tableau and using the desktop version 8 with Analysis Services as my source.

       

      In my rows i have Company and Business Units as the dimensions like:

       

      Company 1   BU 1

                          BU 2

                          BU3
      Company 2   BU 4

                          BU 5

      Calc Company     BU1

                               BU2

                               ...

                               BU5

       

      I want to filter the business unit only for the calculated company so see every business unit in the apropriate Company but see only TOTAL business unit for calc company.

       

      My calculated company aggregates specific business units as ([Company].[x],[Business Unit].[1])+([Company].[x],[Business Unit].[2]) and so on..

       

      Any suggestions (an other way of calculating maybe)?

       

      Thanks in advance,


      Marc