Forum Discussion

jmg's avatar
jmg
Data Storage
04-13-2023

Stuck on trying to create a pivot table with more than one filter

Hello, I am trying to create a pivot table for all of the campaigns that my company is running. Most of these can have an open date range, but one of them needs a closed date range. 

so far, I have the pivot in the widget. I have Campaign in the rows of the pivot. I have Total Amount in the Values. I cannot seem to filter only one of the lines no matter what I try. Please assist. 

Example Table:

Campaign desired date range $
Campaign A open date range $
Campaign B open date range $
Campaign C open date range $
Campaign D open date range $
Campaign E open date range $
Campaign F open date range $
Campaign G 7/1/2022 to 6/30/2023 $
Dashboards & Reporting
Finance Analytics

2 Replies

Replies have been turned off for this discussion
  • david-h's avatar
    david-h
    Cloud Apps
    06-10-2023

    Hi jmg ,

    The filters are applied to all elements of the widget. One solution is of course to include different widgets in your dashboard : one not affected by the date filter (simply deactivate the corresponding toggle in the widget filters tab) and the other one affected by the date filter.

    If you need to have everything in the same widget, then you can use filtered measure plugin : https://www.sisense.com/marketplace/filtered-measure/

    It allows to decide which measure is impacted by which filter. So you could have 2 or more date filters, and have different measure pointing to each date filter, with one filtered on all dates.

    Hope this helps !

    Best, David.