I have the following problem and I don't know how to solve it:
I've the dimension "Area" (Geographical Location) and the dimension Time and what i wanna do is to calculate the porcentage of sales monthly of each area because what i have is the sales of ever day and I wanna see them in the follow way:
Month Area Sale (%) January New York 20.00% January Los Angeles 30.00% January Carolina 50.00% February New York 25.00% February Los Angeles 30.00% February Carolina 45.00% March New York 30.00% March Los Angeles 30.00% March Carolina 40.00%
