Forum Discussion

PeterL1's avatar
PeterL1
Helper I
8 years ago
Solved

Row Total that moves with sort on average

Hi,  I am currently trying to create a row total that would move when sorted alphabetically by an average.   The total needs to move with the Groups when i sort the Average per SQM, so that i ca...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi PeterL1

     

    Try this

    Go to Modelling Tab>>>>>NEW TABLE

     

    NEW Table =
UNION (
    YourTable,
    ROW (
        "GROUPS", "TOTAL",
        "SQM", SUM ( YourTable[SQM] ),
        "SALES", SUM ( YourTable[SALES] ),
        "AVERAGE PER SQM", DIVIDE ( SUM ( YourTable[SALES] ), SUM ( YourTable[SQM] ) )
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi PeterL1

 

Try this

Go to Modelling Tab>>>>>NEW TABLE

 

NEW Table =
UNION (
    YourTable,
    ROW (
        "GROUPS", "TOTAL",
        "SQM", SUM ( YourTable[SQM] ),
        "SALES", SUM ( YourTable[SALES] ),
        "AVERAGE PER SQM", DIVIDE ( SUM ( YourTable[SALES] ), SUM ( YourTable[SQM] ) )
    )
)