Skip to Content
0

YTD total in column on Periodic model

Jun 02, 2017 at 04:15 AM

90

avatar image

Hi Experts,

Need you help on below requirement.

I have a requirement to create report and show the totals of months in the column.

if user select month 2017.MAY, the report should display 3 columns i.e., APR.2017,MAY.2017 and Total(JAN to May 2017).

the first two column can be achieved by override functionality, but the total is not showing correctly for 5 months, it is calculating only for current two months.

Note: Model is Periodic type and account types used in report are AST and LEQ.

is there any way I can achieve this scenario with using custom measures, please provide the MDX formula.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Jun 02, 2017 at 07:18 AM
0

AST and LEQ accounts are ytd even in periodic model. And year.total for YTD accounts is the value for DEC.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Vadim, thanks for your response.

but my requirement is to show the total of all months of user selection month.

user Selection - May 2017

Values in Model Jan-1

Feb-2

Mar-3

Apr - 2

May- 3

Report output

April 2017, May 2017, Total

2 3 11

0
srinivasa reddy Uppada

It's absolutely strange idea to sum month values for YTD accounts! What is the business logic?

If you still need it you have to create custom measure that will not look on the acctype property.

0
karan kothari Jun 09, 2017 at 06:54 AM
0

Hi Reddy,

You can create a dynamic report as below:

1. Make time dynamic through context member. and give reference of the same into report (with activation of member recognition)

1-dynamic-time.jpg

2. Use member offset for all previous months you want to take into consideration.

2-member-offset-for-all-previuos-month.png

3. Attach a local member at the end having total of all the columns.

4. Hide the columns with time period which you do not want to display in the report.

Hope this helps.

Thanks,

Karan


Share
10 |10000 characters needed characters left characters exceeded