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

Look Back
Pivot table help - Measures dont sum — 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 help - Measures dont sum

Accepted answer
58
Views
11
Comments
in Reporting and Analytics for HCM 11 comments

Summary:

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):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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