Forum Discussion
Regarding the filter by condition option in pivot table in the excel
I'm taking Google Data analytics course in the coursera, there they use filter in the pivot table and apply conditions like, less than or greater than, they were using the Google sheets, and I couldn...
Hi! Thank you for sharing your problem here.
I had similar issue in this task, and tried the methods others recommended in this thread. However, it seems that either because of different app version, or because of using macOS the steps jennifaux95 suggested didn't work for me personally - I didn't get to choose which column to expand by, and it automatically expanded by date which led to incorrect results.
I tried looking for alternatives to achieve the same goal, but didn't find any solution. If anyone (especially macOS users!) finds a way to solve, could you please share it here? Thanks in advance!