Group By Fields Not Impacted by Filters

Question & Answer
, ,
1

I’m trying to create a pivot table visual with a sales measure that’s a filtered list of customers down and a filtered list of products across the top. However, if one of the products filtered does not have a customer sales record associated with it, it’s removed from the visual. I need to preserve the filtered list of customers regardless of the product filter. Is there a way to do this? Thank you

2

Hi @dspringer,

Thank you for posting

To preserve the filtered list of customers in your pivot table regardless of product sales, you need to adjust your data model to include all customer-product pairs, assigning zero or null sales where no data exist.
Amazon QuickSight 's native pivot table does not support this directly without such data preparation.

Regards,
Demola