Hello there,
I am new to cross-tabs, I managed to insert one cross-tab with grand totals, i know how to supress or show grand totals.
However I have two challenges ahead of me:
1) I need to insert under the total amount row, one more summary row for average. by default cross-tab calculates the total for me, however I can't find a way to insert any row under the grand total row for the average
2) My second challenge is hiding a column header if the field value is empy. I am hiding the summary field where category group is 2 as per green code below. I right clicked on the forumla and selected "Display string" option and added below check:
if GridRowColumnValue("item.categoryid") = 2 then " "
else
totext(CurrentFieldValue)
this work, however the column heading still displays.
if I try the same code above for supressing the header text field, i get the below error message.
"this is not the name of a grid group for the field being formatted"
Any feedback would be greatly appreciated regarding item 1 or 2.
Thanks in advance 
MD
IP Logged
