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|
No answers yet