pivot table - unpack rows which have the same value

Hi everyone,

I am a newbie on pivot table and I am trying to solve a problem.

My pivot table has row value as date and column as box office revenue. This is a dataset about movie's revenue.
As shown in image1 below, the total revenue for 2012-01-27 is $166.9M, which consists of 4 movies as shown in image2.
the pivot table has summed 4 movies into 1 value $166.9M. This is the problem because later one, when I filter for movies which have revenue less than $10M, this day 2012-01-27 was filtered out because 166.9M > 10M. However, as this is a total revenue for 4 movies, one of them is actually has revenue less than 10M, "Declaration of War": $6.5M.

How can I properly filter for movies with revenue less than 10M in this case?

Thanks a lot

image1.png
image2.png

post an excel example file not a picture with manual created result what you want to achieve

Maybe try dragging movie title into the pivot table under release date and filtering based on that.