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
Sum(Aggr(Min(TOTAL <Carrier> [Contract Share (%)]), <Dim1>, <Dim2>, ..))
sum(Contract Share%) which isn't working.
Please suggest an expression to display the static value for Contract share
You need to manipulate with Num() format?
From your question, I understood that values should always remain static.
You can acheive it by showing it as a dimension or an expression.
For dimension: =Num(/100,'#,##0%')
For expression: Sum()/100 and Under Number tab, change it to Fixed to and Enable 'Show in Percentage'
@sangeetha_changu if you simply paste the image, I strongly believe that won't help for others instead what you have handy in the expression that may helps for sure
i was just using some trial expressions like
i even directly used [Contract Share %] field in expression
which is not giving me the desired results
Do you have some sample data set which concur the same?