Grand Total to Stacked Column Graph

HI Anonymous,

>>X Axis breaks it out into each team across the business, however I have been asked to also include a company total split - after advice or suggestions on how I can display this.

AFAIK, stacked column chart not contains analysis total split function.

In my opinion, you can use original table to create new table with summary records row and use this table as source of stacked column chart.

Sample:

New Table =
UNION (
    Table,
    UNION (
        ROW (
            "team", "Total",
            "Role Type", "BAU",
            "Sales", SUMX ( FILTER ( ALL ( Table ), [Role Type] = "BAU" ), [sales] )
        ),
        ROW (
            "team", "Total",
            "Role Type", "Project",
            "Sales", SUMX ( FILTER ( ALL ( Table ), [Role Type] = "Project" ), [sales] )
        )
    )
)

In addition, you can also submit an idea for this requirement.

Regards,

Xiaoxin Sheng