I am using 2 formula variables based off of date characteristics in a calculated key figure. It appears that in order for the key figure to calculate correctly the 2 date fields have to be in the row. Unfortunately, I want to aggregate at a higher level than the dates. When I hide them, the key figures still break total at the date level. Is there any way of getting the key figure to calculate without the characteristics being in the row.
Any advice greatly appreciated.
Thanks
Bill