Hi,
i hope i will be able to explain my issue.
I am using OBIEE 12 c and this is what I need to do.
I create pivot table and drag rows and columns, however i need to have a bit detailed column under my column that is already there depending on a value from fact table.
But not for every value from my column, just some of the values.
Measure is count. For example , every value count is 3, i need to separate only value2 by its groups. I know i can do it by drill or some other way in another report, but sadly this is the way they want it if is anyway possible.
I will try to write it down under this post,.
COLUMN.value 1 COLUMN.value2 COLUMN.value3
COLUMN.value 1 detailvalue2 detailvalue2 detailvalue2 COLUMN.value3
ROW 1 3 1 1 1 3
