subsidiary views are blank

joshuastockwell

I am trying to create a module which is a summary by a single dimension

 

Source:

Time, Cost Centre, Account

 

Destination

Cost Centre

 

for my destination line item I have Year in the time scale, which creates a subsidiary view. If I click into this I can see the numbers I expect, but the main module has blank rows for each cost centre. Is there a way to summarise the line item for all years?

joshuastockwell

I have found that keeping the line item dimension the same as the main module and using TIMESUM function populates values as expected.

 

 

DavidSmith

@joshuastockwell

As you've found out there isn't a native Top Level for Timescales

Well done on finding Timesum.

 

For information you can set a Total for time and then reference it through [SELECT:Time.All Periods]

 

 

David