Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Ethel
Creator III
Creator III

Set analysis on dimension

Hello!

I have a task: I have to create two tables on the same page. On the first table we show department, vendor type, vendor name and totals. If we choose let's say department A, vendor type A, then we see let's say only vendor nameA and totalsA

At the same time on the second table we should see vendor type A, but ALL vendor names from the company(no filters) for this vendor type and all their totals.

Plus on top of that I have calendar when users can chose year, month, month period or YTD.

Ideally I have to do this on a load level.

Can you please share any ideas how to do it? 

Thanks a lot in advance!

Thanks a LOT in advance! 

1 Reply
vinieme12
Champion III
Champion III

in your second chart just ignore selections on company field example

sum({<Company=>}SomeMeasure)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.