I have a table having amount and budget as KPI and Date as dimension. I have to show a table of trend on KPI Amount. But for the selected month it should show budget. For example when July is selected, it should show budget 400 and amount for the other months. I have attached the sample qvw and data excel.
