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 help - Measures dont sum

Accepted answer


Measures in a pivot table do not sum, instead appear as a 1 regardless of total.

Content (required):

Im new to OTBI and dislike pivot table (OTBI, excel, anywhere!).

I have what I believe is a simple pivot table that counts the number of applications per source/location/day. From the table view I can clearly see there should be five applications for indeed/El Paso on 1/18 and 1/19 but in the pivot it appears as 1 on both days. HELP!

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):


Howdy, Stranger!

Log In

To view full details, sign in.


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