This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have the following scenario :
I want to create 2 calculated columns , one % of US and one % of EMEA where for Group , it should calculate New/Total , Screened/Total , Called/Total.
Is there a way i can use multi row formula for this? if yes what would be the best way. any suggestions will be helpful.
I have a different approach for your problem.
See if one of the results fits your needs.
I would be using Filters and Summarize, Multi-row could be dangerous when the dataset is larger.
I don't understand the TOTAL logic though, in USA Total = Screened+Called, in EMEA Total= ????
I'm guessing he pulled out a sample of his data.
That would be the only logic reason.