Suite Analytics: date + term formula in pivot
Hi, I built a suite analytics workbook (pivot) and I need to add an additional formula to calculate the expected date a bundle will expire. The formula is a function of date that is available on the pivot (say 01.01.2024) + term that is calculated within the pivot. Term is not available in the data set because it can only be calculated within the pivot.
I tried using pivot calculated measures but the start date is only available in a count option. Can it be somehow used as a date that we can add days to?
End Date = Pivot row value
Term = a calculated measure