Forum Discussion
Solved
pick Single cell as denominator
Need to get the rate column as a result.The total columns in dollars as condition should be divided by total of sales. category nsub-cat condition total rate Blank z sales 8 car ...
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Ahmedx
Super User
Super UserBased on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Hi thanks for the solution , but i just couldn't compare with my data .pls look at the modified question
- Ahmedx
Do you have only car or many groups in your category column?
if there are many groups, then please post an example of several groups.Yes i do have many groups but those shouldn't have the rate nos
