Hello,
I've attached an example of my issue below. I am trying to make a table with the same column fields but it only displays values in which a company has 2 or more businesses in a single year OR that company has "Consulting" as a business but has 2 products in a given year. All of this is filtered again so that there is a company total dollar threshold. So basically for any given year and above a certain total dollar threshold for a company, only display companies that have 2 businesses OR consulting and 2 products. What Kind of formulas do I need to achieve this? I will then be uploading this data into PowerBI
Thanks a lot for the help.
I've attached an example of my issue below. I am trying to make a table with the same column fields but it only displays values in which a company has 2 or more businesses in a single year OR that company has "Consulting" as a business but has 2 products in a given year. All of this is filtered again so that there is a company total dollar threshold. So basically for any given year and above a certain total dollar threshold for a company, only display companies that have 2 businesses OR consulting and 2 products. What Kind of formulas do I need to achieve this? I will then be uploading this data into PowerBI
Thanks a lot for the help.