Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
The Expressions are:
Open Count = SUM({<[Created]={'>=$(vStartDate)'}>} OPEN_TICKET_COUNT)
Total Count = SUM({<[Created]={'>=$(vStartDate)'}>} TICKET_COUNT)
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.