cancel
Showing results for 
Search instead for 
Did you mean: 

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

jmg
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 $
1 REPLY 1

Angelina_QBeeQ
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.

Angelina_QBeeQ_0-1681453876722.png

 


Always here to help,
Angelina from QBeeQ
angelina.bulgakova@qbeeq.io
QBeeQ  - Gold Implementation and Development Partner