Pivot Table - Disable Column Splitting for all the measures in pivot

[muhammedraleen]

Hi All,

I have a pivot table with three dimensions Emp. No, Emp. Name, Designation and one measure with No of Papers. I have added two dimensions Day and Resubmitted in the Pivot Columns. Now the measure column is being divided by Day and Resubmitted columns. Refer below image.

 Now, what is required is, when I add a new measure, that measure should not be divided by the Day and Resubmitted        dimensions. 

[anat]

you can bypass the day field in measure

[muhammedraleen]

Hi @anat ,

Can you let me know how to bypass the day field from measure... Is it  this way ? {$<Day=>}

[anat]

yes,count({<Day=>}ID)

[muhammedraleen]

Hi @anat ,

This is not working for me.

[muhammedraleen]

Hi Team,

If this is not possible. Is it possible to add a measure in the dimensions..?

[anat]

if possible can you share your set analysis logic....

[muhammedraleen]

Count({<Day=>} distinct reference_no_rolewise)