Repeat local member in column for every new entity

[former_member590808]

Hi

In our column axis we have 3 dimensions fetched, APL_ENTITY -> APL_KEYFIGURE -> APL_CATEGORY. I want the local formula of growth to appear after REV_TOT category which will divide previous two columns everytime. How should I place the local member. If I am positioning it after column axis it appears at the end of report. I want it to repeat for every entity as depicted below. Is it possible ?

Regards,

Neha

[former_member186338]

Your column axis looks asymmetric - how category is related to keyfigure?

[former_member590808]

For each category I have multiple key figure appearing.

[former_member186338]

"For each category I have multiple key figure appearing." - not clear, what do you mean!

I see 2 keyfigures: COUNT and AMT

And different set of categories under different keyfigure:

COUNT: PROP_ADD,TOT_PROP

AMT: AVG_CTC,BUD_CTC,REV_TOT

How do you maintain relation?

[former_member186338 · Accepted solution]

Please read my answer here: https://answers.sap.com/answers/12902345/view.html

And accept this answer as correct!

[former_member186338 · Accepted solution]

P.S. You have to use grouping on your APL_ENTITY dimension!

Look again at my sample in the link provided!

[former_member590808 · Accepted solution]

Worked perfectly! I put the formula on APL_ENTITY dimension and am getting the report in the expected format

Thanks Vadim.