Summary column

Hello guys,

I've noticed that my REV02 module doesn't have the annual summary columns like the screenshots from the video lessons have. I don't know where I've missed adding this, but I've only noticed the difference while doing the activity 13.9.1 UX page. Can anyone share some tips on how I can fix this now? Thank you

Accepted answers

abhay.kanik

@zolzaya

'Any' will work better than All, It will turn on the summary even if any single item is selected in hierarchy.

All comments

Misbah

@zolzaya

That is because of the filter that you have applied on the module. If you wish to include FY totals as well then you will have to include FY in the filter.

Misbah

abhay.kanik

@zolzaya

You have to turn on the summary in the filter line item so that it will include the parents. use 'Any' for Boolean .

Thanks

zolzaya

Hello guys,

Thanks for the tips but I still can't include the Sum in my filter.

This is my current configuration on the filter of this Saved View.

Misbah

@zolzaya

Go to SYS00 Time Setting Module
Go to BluePrint mode of the module
Find out Forecast Period? Line item
Go to Summary of the Forecast Period Line item
Change the Summary to All or Any from None.

Misbah

abhay.kanik

@zolzaya

'Any' will work better than All, It will turn on the summary even if any single item is selected in hierarchy.

Quick Links

Can you help?

Unanswered questions

How do i build a ragged hierarchy?
I have my dataset attached below
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?