Pivot table help - Measures dont sum
Measures in a pivot table do not sum, instead appear as a 1 regardless of total.
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):