Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Pivot table in BI Publisher — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Pivot table in BI Publisher

edited Jan 5, 2018 5:54AM in General Transactional Reporting (OTBI) 5 comments


Can't change Formula value to 'No Formula'


Hello guys,

I am struggling to change the function of measure section of my pivot table in BI Publisher. In OTBI, pivot table worked correctly. Using the same fields in BI Publisher, for some reason BIP automatically assumes COUNT function instead of default or NO function in field formula. Please see the images. I don't want BIP to count, I want BIP to show the Element Entry values as I can see in OTBI.

Can someone please help me to understand what I am doing wrong?

Thank you in advance,

Alvaro Couto

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!