Hi All,
I need to create report by having one metric which is grouped by a Country, Region and Company dimensions. So in each i dimension i have to apply Sub total. For example : I need to have a Country wise distribution of Amount, Region wise and Company wise Distribution in turn i have to calculate Region & Country Subtotal.. So i have applied union All to get each subtotal and over all total . Is there any way to get the result with out using union all function
Regards,
Guru