This content has been marked as final.
Show 2 replies

1. Re: Counting and Finding sum of combination of Dimensional attributes
Luciano Vasconcelos Jul 7, 2016 10:56 AM (in response to amulya.sharma)1 of 1 people found this helpfulDo you know LOD?
Here i keep the total of Sale using Fixed clause.
SUM([Sales])
/
SUM({FIXED: SUM([Sales])})
This is how i'd count:
Sum(If [SubCategory] = "Phones" then 1 Else 0 End)
You have to adapt it.

2. Re: Counting and Finding sum of combination of Dimensional attributes
Manideep Bhattacharyya Jul 7, 2016 11:02 AM (in response to amulya.sharma)1 of 1 people found this helpfulHello  There are many ways to solve this. This one is the easiest and simplest by creating calculated fields.
Thanks
Manideep