why you didn't use filter function here and does it make different if you use it?

because we cannot always rely on filters to make our reports. Inside the business world you might be required to find out the total sales for last year for product category red. Then you can be asked to compare the LY sales for product category red against all products for LY or for LY products in category green.

Follow this topic