Showing results for 
Search instead for 
Did you mean: 

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

7 - Data Storage
7 - Data Storage

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 $

10 - ETL
10 - ETL

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
QBeeQ  - Gold Implementation and Development Partner