I'd like to have two occurences of the same pivot data field in one table. I
have a date field, and I'd like a monthly grouped version of it to appear in
the page area, while the detailed date field appears in the rows. In other
words, I want the user to be able to limit the view of dates by the month
that is desired to be viewed. So there are three months of data, and if the
only one that is desired is June, they would select page June (or maybe even
the first level row area, with the second level being the dates themselves).
Calculated field doesn't do it, because that can only go into the data, but I
want something that is a copy of the field in the row area. Any way to avoid
duplicating my source data (it's a good amount)?
--
Boris