Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have 3 fields for Amount calculation, depending on FiscalYear. they are: FiscalYear1Amount, FiscalYear2Amount, and FiscalYear3Amount. These are flag fields, where the calculation for the amount for Fiscal Year 1, is where
sum({<FiscalYear1Amount=1>} Amount)
i would like to see a Trend line by Fiscal years, but i do not have a date field or fiscal year field in my dataset. i am trying to avoid having to use a 'master calendar' for this solution.
Trying to achieve something like this:.thanks!