below is my request. i have been tried several way. but it was not working.
1. Table1 has dozens of product name columns like A, B, C, and D. And there is a column the region of production 2. I will Select Region for Slicer1. 3. When I select a specific product in Slicer1, I want to assign 10 points to that product and 5 points to the others. 4. i will show point status in the chart.
I can't implement it well with the if function. If there is a way, I'd appreciate it if you let me know.