How do you get your data? If you are defining it (i.e., in Excel, SharePoint, or directly), you can format it as in your original table, or using an expression like the one below:
ClearCollect(
MyData,
{ Quarter: "Q1", Manager: 95%, Supervisor: 45%, Internal: 85% },
{ Quarter: "Q2", Manager: 90%, Supervisor: 50%, Internal: 90% },
{ Quarter: "Q3", Manager: 55%, Supervisor: 45%, Internal: 87% },
{ Quarter: "Q4", Manager: 60%, Supervisor: 85%, Internal: 45% })
If you already have the data in the format from your last post, you will need to "pivot" the table, to move some of the rows into columns. For this case, you can use this expression below:
RenameColumns(
AddColumns(
Distinct(MyData2, Quarter),
"Supervisor", LookUp(MyData2, Type = "Supervisor" And Quarter = Result, Total),
"Manager", LookUp(MyData2, Type = "Manager" And Quarter = Result, Total),
"Internal", LookUp(MyData2, Type = "Internal" And Quarter = Result, Total)),
"Result", "Quarter")
I've attached another version of the same app to this answer (ForumThread335008b.msapp), feel free to open it to see how you can implement this scenario.
