Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I would like to calculate Unit Price / Cost of every cost element in below table (See capture PBI).
ie. Unit selling price (Row 2 / Row 1) and Unit Distribution cost (Row 4/Row 1).
Is there any way to do it in curret structure (See Capture Data model) ?
PBI
Data Model
Basically KPI is stacked vertically from the original data (excel) and dates are unpivoted (within BI).
Value of respective KPIs are entered in Value column.
Desired Outcome
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
14 | |
10 | |
7 |