We have year wise Contract Share% for 2018,2019. How to display the constant Contract Share % per year across the dimensions and KPIs in a pivot table
Contract Share comes from an inline table in below format..
|Share_Date||Share_Year||Share_Month||Plant||Carrier||Contract Share (%)|
and key has been created Share_Year&'_'&Share_Month&'_'&upper(Plant) &'_'& upper(Carrier) as %Key_ContractShare,
To Map the key in KPI table i.e. Year([Ship Date])&'_'&Month([Ship Date])&'_'& upper(Plant) &'_'& upper(Carrier) as %Key_ContractShare,
Below is the screenshot which is showing wrong values for Contract Share %. Need help in correcting
The actual Contract shares are below
Min(TOTAL <Carrier> [Contract Share (%)])
If this is not working, can you explain one row how the value calculated?
The expression you suggested is working for few carriers --- Min(TOTAL <Carrier> [Contract Share (%)])
But for some of the carriers it is not working
To explain more about the rows, The Data from Sample file is the KPI data we get from Database and Sample2 is the inline data that we created for Contract share for each year based on plant and carrier.
We are trying to link Contract Share data to KPI data through key i.e. %Key_ContractShare. Let me know if you need more details. We are looking for quick help. Thanks in advance
This expression worked for us --- Min(TOTAL <Carrier> [Contract Share (%)])
But the 'Total' (Total per plant) in the Pivot table is showing the minimum value. As per the excel statis data for Contract Share the Total should always be 100% .
Could you please suggest on Total as well. Thanks in advance.
Sum(Aggr(Min(TOTAL <Carrier> [Contract Share (%)]), <Dim1>, <Dim2>, ..))