Matrix type data table

(1) Share

Report

Posted on by guyinkalamazoo

174

I need advice/direction. The business scenario: I have a gallery that lists KPIs for projects. Each of these KPIs includes an Annual Estimated Savings total, Annual Actual Savings total, and an Annual Forecast Savings total. These are all aggregated numbers and general "header" data. Each month a KPI actual is entered and is related to the selected KPI. What the business wants to show is a list of KPIs for a selected project and then a sublist of monthly data, starting with the month selected in a datetime picker. I have all the initial requirement, but I am struggling with producing that secondary monthly value list. This is a visual sample of what they want. I've highlighted the associated table in "yellow". I was thinking of doing a horizontal gallery (monthly values) embedded into a vertical gallery (KPIs), but then how do I tie the horizontal values to the month? Thanks for any advice.

Categories:

General

All responses (1)

Answers (0)

SaiRT14 317 on at

Like (0)

Report

Matrix type data table

Good amount of reporting can be built using Power BI- suggest to business,

But to answer:

-Items property of this vertical gallery - Filter(KPITable, ProjectID = SelectedProject.ID)
-Items property of the horizontal gallery - Filter(MonthlyValuesTable, KPIID = ThisItem.ID && Date >= DatePicker1.SelectedDate)

MonthlyValuesTable is linked to the KPITable by a foreign key