I know this is possible and I've found a few answers but I'm having trouble with this:
I have a cross-tab listing our 3 stores across the top. I need each line to be a different formula and also include the minimum date and maximum date on each line. So,
| Store 1 | Store 2 | Store 3 | Total
Row Descr | Min Date | Max Date | formula1 |
Row Descr | Min Date | Max Date | formula2 |
I know having Min and Max date on each line is redundant but that's ok.
So Far I have:
Column - Store.Name
Row - @minimum [formula=Minimum({?FilterDate})] I don't know how to add a column with the Max Date
Sumarized fields 1- @price [formula={PUBLIC_TransactionEntry.Price}*{PUBLIC_TransactionEntry.Quantity}]
I want to add: @transactions [formula=DistinctCount ({PUBLIC_TransactionEntry.TransactionNumber})]
and other formulas or filters per line
Thanks for your help!