Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
wnorwood
Contributor III
Contributor III

Limit Based on Selected Expression Value in Straight Table

Hello,

I have two straight tables.  One that is at a summary level and one that is the details.  I would like to be able to limit the details based on selections made in the summary.  The catch is that I want to be able to do this by selecting a value in the table and apply limits based on the column it is selected from as well as the row (the dimension).  Below is a sketch of what I am trying to do.

Can someone tell me if this is even possible?  Many thanks!

Open Tickets2.png

The Expressions are:

Open Count = SUM({<[Created]={'>=$(vStartDate)'}>} OPEN_TICKET_COUNT)

Total Count = SUM({<[Created]={'>=$(vStartDate)'}>} TICKET_COUNT)

1 Reply
wnorwood
Contributor III
Contributor III
Author

Quick note... just noticed that I put 7 tickets in the Total Count details.  That should have just been through a1 through a6. Got a little carried away with the copy/paste.