multiple conditions in SET analysis

[Anonymous]

Hi

In the attached file, I want to see sum of sales for product P3 and also Sales for specific month. how to achieve this?

John

[Anonymous · Accepted solution]

Hi,

Try this app. For your product P3, there is just one month(dec) avaiable, but when you add more months, you will just need to change the set analysis for those you want

Best Regards,

[Anonymous]

For professional job

you can add variable as Month and do not implement hard code

in your sample I define 'vMonth' and use it in set analysis and change it form Input Box

you can do this for Product too.

hope u enjoy it