Hello,

I have 3 quick filters i.e. Transportation, City & Name.

I would like to display the 2 calc fields wrt to month without creating any parameters in place of quick filters because relevant values will not working as expected.

Need to pass all the below  filters and match the results.

Avg= countd(TRXID)/Countd(date)

LSA & LS are pre calculated fields

Ex:

By Default

When Transportation="All", City="All' and Name="All'  

Display same value in both calc fields for change in Transportation

When Transportation="Air", City="All' and Name="All'                                                                                             When Transportation="Ground", City="All' and Name="All'

When Transportation="All", City="Oklahoma City' and Name="All'

When Transportation="Air", City="Oklahoma City' and Name="All'                                                                      When Transportation="Ground", City="Oklahoma City' and Name="All'

When Transportation="All", City="All' and Name="Justin Ritter'  

    When Transportation="Ground", City="All' and Name="Justin Ritter'        

    When Transportation="Ground", City="Oklahoma City' and Name="All' 

    When Transportation="Ground", City="Oklahoma City' and Name="Craig Reiter' 

I hope it is clear. Please let me know for any clarifications.

Thanks!