Hi,
We have requirement to show percentage of a metric based on date(month and quarter). We have used below expression to calculate the same.
=if ([^Date Type]='YTD',(Sum(ChargeableTimeBorrowedFTENbr)/$(vCurrentMonNr))/(Sum(TOTAL <[Date]> ChargeableTimeBorrowedFTENbr)/$(vCurrentMonNr)),
if ([^Date Type]='QTD',(Sum(ChargeableTimeBorrowedFTENbr)/$(vCurrQTDMonNr))/(Sum(TOTAL <[Date]> ChargeableTimeBorrowedFTENbr)/$(vCurrQTDMonNr)),
(Sum(ChargeableTimeBorrowedFTENbr)/count(distinct Datekey))/(Sum(TOTAL <[Date]> ChargeableTimeBorrowedFTENbr)/count(distinct Datekey))))
This expression value is coming fine for MTD data both in pivot and trend chart. But for QTD data pivot table metric values and trend chart values are different even though same expression been used in both. both the charts are exact replica of one another just the chart type is different.
Not sure why trend is showing different values. Any suggestions for this are appreciated.
Thanks in Advance