hi , i really want this KPIs to be on the right track.
what i want is :
*Calculation of Average YTD , on Table and Bar Chart.
**If i click the filter on Jan + Feb , there will the Average YTD on Bar Chart , And Table Visalization. I wish on my table , I have Average YTD at the end of the table ( YOu see the Blank square i draw ) ,there should have an Average YTD for all KPI.
** on the Exisiting Bar Chart , the % TY VS LY , aren't meet the expectation. what i want is the average YTD , this should be the right Data.