Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Buddies,
Can u please help me out to calculate the count in straight table
For example:
if i do sum(total field) i'm getting total sum but i'm expecting sum by year wise. please help me out. Thanks in advance.
FiscalYear | Service Type | Field | count(total field) | Expectaion |
FY13 | Type3 | 13 | 239 | 38 |
FY13 | Type4 | 25 | 239 | 38 |
FY14 | Type3 | 29 | 239 | 71 |
FY14 | Type4 | 42 | 239 | 71 |
FY15 | Type1 | 1 | 239 | 130 |
FY15 | Type2 | 5 | 239 | 130 |
FY15 | Type3 | 68 | 239 | 130 |
FY15 | Type4 | 56 | 239 | 130 |
May be this?
sum(aggr(sum(total <FiscalYear> Field),FiscalYear,ServiceType))
Count ( total <FiscalYear> field)
Sum ( total <FiscalYear> field)
May be this?
sum(aggr(sum(total <FiscalYear> Field),FiscalYear,ServiceType))
Hi Vineeth,
Thanks for reply, but its not working please check attached file
Use sum (total <FiscalYear> field)
On mobile , can't check the app sry
What is field here? Is it an existing expression in your straight table??
Then use
Sum (total <FiscalYear> Aggr (sum (Field),FiscalYear))
did you try the above, sivaprakash.t , we only need to Aggr() on the dimension we need the total on.
try this:
1)Add Fiscal Year as Dimension.
2)Write expression be like:
=Count(num( field))