Hi Guys,

 

I have a cross-tab where I've got all columns/numbers I need. But, I'd need those columns for calculation purposes only.

So, I’d need to hide them except row headings and add several new columns that would use those hidden columns numbers to calculate new numbers.

I would very much appreciate if you could help me figure out how to hide columns in a cross-tab and add some calculated ones there.

Another challenge in a calculated column is I’d need to calculate numbers from a specific column of the cross-tab.

E.g., ([column1]*1 + [column2]*2+…+[column5]*5)/([column1]+…+[column5])

It’s the same formula for all rows including grouping/footing.

 

Thanks

Hi elen1,

The cross-tab project was postponed but I'll return to it soon.
If I find a solution I'll post it here on this forum.

Best