Regarding number of columns in a pivot table

[#1]

Hello Friends,

I appreciate your time.

I have a pivot table with dimesions contractid, contractname,planid , utility type,formid and expresion is

sum(sales)/trans#

where trans# is :No of lines coming up for that specific combination of contract, plan, utilization type, form Id

So how to get that line number in a pivot table?

Kindly let me know.

Kind regards,

Kiru

[#2 · Accepted solution]

no, i don't think it would.

[#3]

Thank you so much!

Kiru