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

[jmg]

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	$

[Angelina_QBeeQ]

Hi @jmg ,

Check which option is selected (Slice/Filter or Highlight) on the Filter tab. I can assume "Highlight" is enabled.

Always here to help,
Angelina from QBeeQ
[email protected]
QBeeQ  - Gold Implementation and Development Partner

[david-h]

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.