Oracle Transactional Business Intelligence
Pivot table in BI Publisher
Can't change Formula value to 'No Formula'
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,