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
angelina.bulgakova@qbeeq.io
QBeeQ  - Gold Implementation and Development Partner