filter combined dimensions

tableaucommunity@tableau.com — Mon, 30 Sep 2013 11:30:26 GMT

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

Content in Tableau Community Forums

filter combined dimensions