Hi,
I am using CR10 and SQL 2005. I have a cross tab with:
Rows: {@category}
[which is a formula resulting in a 3 range series (1-5, 6-10, 11 or more)]
Cols: Table.costctr
[Field which contains a cost center number]
Summarized Fields: Sum of @count and
Sum of Table.Spend
[where {@count} is a count formula for transactions that removes voided transactions, etc (if x then 0 else +1)//// Spend is a dollar amount per transaction]
May be a dumb question, but how do I get the AVG of:
Sum of Table.Spend/Sum of @count
to show up in the summarized fields section instead?
Thanks,
I am using CR10 and SQL 2005. I have a cross tab with:
Rows: {@category}
[which is a formula resulting in a 3 range series (1-5, 6-10, 11 or more)]
Cols: Table.costctr
[Field which contains a cost center number]
Summarized Fields: Sum of @count and
Sum of Table.Spend
[where {@count} is a count formula for transactions that removes voided transactions, etc (if x then 0 else +1)//// Spend is a dollar amount per transaction]
May be a dumb question, but how do I get the AVG of:
Sum of Table.Spend/Sum of @count
to show up in the summarized fields section instead?
Thanks,