Hi, I’m trying to get the percentage of total revenue by each of the top 10 Brands (dimension).
The logic would be: (Revenue per Brand / Total Revenue)*100. But since it’s the top 10 Brand, if I try to do a table calculation it will not get the global Total Revenue but only the sum of the top 10.
I need the Total Revenue considering all the brands from the database, can you help?
Best answer by olgaView original