Categories
Pivot table in analysis - aging buckets

Summary
how to create a pivot table with columns as calculated field
Content
i am trying to create date buckets of 0-30 days, 30-60 days in OTBI. I was able to add a calculated column. however when i create a pivot table with the calculated column i get a blank. Is that a bug in OTBI or is that how is it working as designed. I could not get the bucket on the column - the data just show as blank.
Comments
-
Hello new.bi!
There is not enough information in your request to assist you, I strongly recommend adding detail about the objects being used in your pivot structure and perhaps a screenshot of the layout being implemented. By your comment alone, there is no technical information that can be used to try and evaluate why your report is not functioning as intended.
The data being blank or missing could be due to an invalid measure, or clause-resulting-in-null for the objects in your table layout. More information is needed in order to obtain any value-added assistance.
Thank you, and have a great morning!
-JF Carpentier
Senior Business Intelligence Consultant
jfcarpentier@modulusdata.com0