I have another request. Please look the below image
there are two things i need to achieve here using KPI
1.For PRICE i should compare with the previous weekday like if am on thursday i need to compare the price with wednesday if it is high than the previous day i have to show the UP arrow, if price is less have to show down arrow as displayed in the below image.
2. For TOTAL PRICE Current week all days total value is showing , so i need to compare current week total price with previous week total price , if current week total price is higher than the previous week then i have to show UP arrow, if total price is less have to show down arrow.
Based on the price the KPI arrows needs to display UP or DOWN.
For PRICE need to compare with PREVIOUS DAY PRICE and display arrow accordingly
For TOTAL price need to compare with PREVIOUS WEEK PRICE and display the arrow accordingly
Have you tried creating a KPI? If so, could you share a packaged workbook showing what you've tried? This KB is a good starting space: