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

    filter combined dimensions

    Marc Roest



      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

      Company 2   BU 4

                          BU 5

      Calc Company     BU1





      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,