My vertical table is
Material Group Today Lastyear Today Trend
Material Group is Master data
Today is calculated as KPI where(Calendar day=CurrentDate())
Last year today RelativeDate(CurrentDate();-365)
Trend is Percentage of today and last year today
the problem is Trend values are showing wrong ones. It shows the percentage of values where the columns show whole year data ın each column not a daıly data.
I wonder how to achieve the right calculation, which percentage of the daily values on the report.