Forum Discussion
Solved
Number with percentage
Hi
I have a sale dataset of fruits. I want to create a visual table with the total count or sum of sales with percentages in single cell,
| Fruit Name | Sale Qty | Percentage Contribution | Required This type of data |
| Apple | 10 | 10% | 10 (10%) |
| Bananas | 40 | 40% | 40 (40%) |
| Kiwi | 50 | 50% | 50 (50%) |
| Orange | 10 | 10% | 10 (10%) |
| Grand Total | 100 | 100% | 100 (100%) |
Pls try this
Contribution Required This type of data = SUM('Tatble'[Sale]) &" ("& FORMAT( SUM('Tatble'[QtyPercentage]),"Percent")&")"
