Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey Experts,
I am having an issues while creating a formula for Aggregation(Sum or Subtraction) on Record level on a Single dimension column.
my data is like in the below format for your referance.
Country | Sales |
India | $150 |
Australia | $200 |
America | $500 |
China | $750 |
Japan | $620 |
Now i need to get aggregation on Sales of India+America and China-Japan.
Please Help me on this.
TIA,
Habib Shaik.
Solved! Go to Solution.
@Anonymous
you can try formula like below
Proud to be a Super User!
Hi Habib,
I would suggest you create some groups of the countries. Then it's easy to get "sum of" and to show them in the visual. Please refer to the snapshot below.
Best Regards,
Dale
@Anonymous
you can try formula like below
Proud to be a Super User!