jmg
Data Storage
Joined 3 years ago
User Profile
User Widgets
Contributions
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 $2KViews0likes2Comments