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]

simply say sum(sales)/count(trans#)

[#3]

Hello Ramkumar,

I appreciate your time.

actually, there is no trans# field.

But it is the number of lines containing the fields contract, plan, utilization type, form Id.

So I have done the expression as sum(sales)/(count(contractid) * count(contratname) * count(plan) * count(util) * count(foemid))

I hope i am in the right tract 😞

please let me know in case if there are any other solutions

Kiru

[#4]

Then simply say count(1)

sum(sales)/

count(1)

[Anonymous]

you may want to create the field in your table and do a sum or a count distinct. can you attach sample data/qvw?

[#6]

I have attached a sample application and as per the appln the count has to be 4

because there are only 4 combinations of rows

but it is not giving that instead.

Kindly have a look at let me know

Kind regards,

Kiru

[#7]

Hello Jsara,

Thanks and 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

I have attached the application for your reference,

In this case the expression should be sum(sales)/4

because there are only 4 rows with different combinations.

Kindly let me know if you need any further details.

Thanks,

Kiru

[#8]

SALESAMOUNT/count(total SALESAMOUNT)

[#9]

Please find attached.

[#10]

I sincerely appreciate your time. Just a thing to confirm, will it affect the expression values if I add some more fields inside dimension say

contract, plan, utilization type, form Id, prodia,prodname,cartegoty,norx

and I am going to use the same expression SALESAMOUNT/count(total SALESAMOUNT)

and the count has to be only the combination of contractid, contract name, plan, utilization type, form Id,

Kindly let me know

Kiru