Display the number of records in a pivot table

[#1]

Hi,

Can anyone tell me the expression to calculate the number of records in pivot table?

Attached is the screenshot.

I have used COUNT(COUNTRY & [FIELD NAME] & [FIELD VALUE] & [SOURCE SYSTEM] & BU & COUNTRY ) or Count (Country).

When i try to put the expression like count (Expression) its displaying a error msg.

[#2]

The record count displayed here is wrong

[swuehl]

Could you specify what you mean with 'number of records'?

Are you referring to the number of lines?

Try

COUNT(DISTINCT COUNTRY & [FIELD NAME] & [FIELD VALUE] & [SOURCE SYSTEM] & BU & COUNTRY )

But if you pivot / collapse some dimensions, this might not reflect your current table layout.

If your dimensions are fully expanded, above should return the number of cells per expression, I think.

If you are referring to the number of records used in your aggregations, I think you would need to look at the fields used in the aggregation functions, not the dimension values.

[sunny_talwar]

Would you be able to share a sample?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

[Anonymous]

Hi harshuharsh0811,

Calculate the count on a variable, then call the variable on Title.

Vars: =COUNT(DISTINCT COUNTRY & [FIELD NAME] & [FIELD VALUE] & [SOURCE SYSTEM] & BU)

Title: ='Summary '&YourVarName&' records'

Kind regards

[#6]

Thanks a lot .It worked

[Anonymous]

Hi hasrhuhars,

I am happy to read this.

Please, mark answer as correct for help other users.

Regards!