@Christian Berg-0racle can it be done via formula like if else. is there any example that i can read on? Thank you

Thank you so much for the explanation. Yes, my original date is in calendar format. I followed your steps and concatenate chars into a single piece of text using the YYYY and MM from functions. When I concat the 2 column using ||, there is also a space in-between, how do to get rid of the space? Thank you.

Thank you so much. I re-arranged the order in the table prompt and it work. 😆

Hi, When i view the result, the date column are showing 2021 & 2022 as follow But when I drag it under layout, table prompt, it does not have the month Jan & 2022 So i am not sure what I did wrong?

Yes, I have data for Jan 2022. It actually appeared in the result view column as well. But when I drop it under 'Table prompt', it didn't give any option for Month Jan or Year 2022. So I was wondering if I did anything wrong.

Hi Sir, For 2nd question, is that I have 3 column (called A,B,C) and each of these column has formula "SUM(case when "column" = 'ABC' then 1 else 0 end)" How do I add the total for the 3 columns,A,B,C? Thank you.

Opps, sorry. I am using Oracle Business Intelligence Enterprise Edition 11.1.1.7 (OBI)

Hi all, I got it working, one of my column got error that why it wasn't working initially. Thank you so much for the help!😃

haha! it really don't work 😅 Guess no choice but if anyone had a workaround, please share with me.

hihi.. I think the product is using Oracle Business Intelligence Enterprise Edition 11.1.1.7 (OBI). Thank you.