double aggregation in domain

[terija129]

Hi,

 

I'm sure someone had to deal with this case as it's very common business requirement. But I could not find any articles or answers. We have data in relational data source prepared at month level for each asset. On the asset dimension data needs to be summed up, but on the calendar dimension we need last value (can be average, if that's easier). It's easy to do that in Studio report, but we need to expose this data through Domain and Ad-Hoc designer. May someone has similar experience?

 

Year	2013								2013 Total	Grand Total
Quarter	1			1 Total	2			2 Total
Asset | Month	1	2	3		4	5	6
43464	200	400	400	400	400	400	500	500	500	500
43471	57000	57000	57000	57000	51000	51000	57000	57000	57000	57000
Grand Total	57200	57400	57400	57400	51400	51400	57500	57500	57500	57500