Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Calculated budget % share row (calculated row?)

Hi,   I have a pretty normal matrix layout below. But I need to add a budget (without regional or branch splits) to row 10 and a % variance versus budget row in row 11. Please can you tell me how t...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous,

     

    You can refer to below sample if it suitable for your requirement.

     

    Tables:

     

    Table formula:

     

    SummaryTable = UNION(FirstTable,SecondTable,SELECTCOLUMNS(SUMMARIZE(FirstTable,FirstTable[Month],"Value",SUM(FirstTable[Value])),"Region","Summary","Branch","Total","Month",[Month],"Value",[Value]))

     

     

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

If it's impossible to do this please can someone confirm? How about if I create table 2 below, is this possible? Can I create calculated rows in a table like this (rather than calculated columns?)?

 

 

 

Thanks for any help,

 

CM

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

 

You can refer to below sample if it suitable for your requirement.

 

Tables:

 

Table formula:

 

SummaryTable = UNION(FirstTable,SecondTable,SELECTCOLUMNS(SUMMARIZE(FirstTable,FirstTable[Month],"Value",SUM(FirstTable[Value])),"Region","Summary","Branch","Total","Month",[Month],"Value",[Value]))

 

 

 

Regards,

Xiaoxin Sheng