Pivot Table count Issue

[sreenivas]

Hi

I am facing the issue to get Count of the Values in the Pivot Table

[sujeetsingh]

Please explain the functionality.

[vivientexier]

Use an expression not a dimension.

[sreenivas]

To get the Total  Count of Values Based on the Month

[#5]

Hi Srinivas,

Are you looking for the count of the contracts and id's coming multiple times across the Month?

[er_mohit]

hiii try this

i didnt open your file because i used personal edition but how if i get you properly then see the attached file.

hope it helps

[sujeetsingh]

Try this sample.

[sreenivas]

Hi

Count of  Values i can get directly ,

but using Pivot o Month some values will be null  So I need to get the Count of available values

[sreenivas]

Actuall i need the Count of Values Present in the Months

[sreenivas]

See in the attached image the wrong value is highlighted Instead of getting Result 2 i got 1