Can we add variables under pivot type in reports

[RojaNalluri]

I can see "Variables" under multi pivot type but is it possible to add variables under pivot type in reports?

[Bhavya11]

hi @RojaNalluri ,

yes you can select variables but only  It is possible to select at most 3 columns.

If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful."

Thanks,

BK

[RojaNalluri]

I can see that we do have Variables under multi level pivot

But wanted variables under pivot (if the requirement is possible can you please guide me how to achieve this)

[Bhavya11 · Accepted solution]

Hi @RojaNalluri ,

you cannot directly use the variable in pivot  reports instead of that you can create Database view like this

Database view result:

in report select type as pivot 

once you click on the count will give detailed information.

If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful."

Thanks,

BK

[RojaNalluri]

Hi @Bhavya11 

In the above report we do have 'empty' and 'total' under parent column , what does empty indicate here?

Just confused as both empty and total has same count.

Thanks,

Roja