Thank you steve and Gianni!

Will do!!!thank you!

thank you .. !

Well i just wanted to get rid of that square boundary lines (green) and show just the label.

AGO function?.. ok.let me look at that option!.. thanks!

Thats the table structure. yes I am trying to get A, B, Year, Amount only. yes. there's nothing .. because there's no data on that .. so my question was is there anyway I can get 2020 1000 to 2021 1000x1.02.. Thanks~

Thanks Gianni, I just posted to forum oracle :) . I guess there's no way to do it. i just wanted category to show on the bar all the time. instead of the number. i can make it with Tree map .. but Stacked bar graph. since it uses Value to make that Label available.

is there anyway We can put other attribute to show? It's driven by the Values.. but wish i can control what to show in there.

Gianni, I always thank you for the help. I solved the problem by setting the Share and Access Edit. I set content author role to Edit in Share and Read-only in Access tab from DV Console | Content tabs. It worked as it should now.. thank you again!!!!!!!!!!

Thank you also I just found Add Notes feature that accomplishes what i wanted. .

Thanks.. I tried aggregate on OAS and it works great. ~ So anyway to make the total sort work? by desc..

Gianni, I tried on DV part ant it looks to be working. I am working on OAS and created the Measure as a attribute. Aggregate (Amount by Column 1 & Column2 ) and then created the filter. I added column total for the row and it seems to pick out what I wanted to be. I will finalize query and see if i can get what i want.…

Gianni, oh it's from Subject Area.. Now you want to filter the rows of your pivot based on the total of Amount (all the FY summed together by COLUMN1 and COLUMN2). ——-I will try this!

Here's the result section look , Amount Total will be generated after click on Column level grand total. Should I put some calculation on criteria?

It looks like this on result, so amount total is after I selected Column total accross. Amount Total is driven by result only. I was hoping to control by rows.. or I can some formula from criteria section.

attachment still not working~ hm.

Sorry for lack of explanation. Here's what my pivot looks like on "classic" analysis it's data set that gets pivoted. Dataset look like listed below as a FACT Table. COLUM1 COLUM2 FY Amount A B 2020 150 A B 2021 0 A B 2022 200 C B 2020 100 C B 2021 90 C B 2022 20 4A U01 2020 90 4A U01 2021 10 4A U01 2022 0 After I created…

ok.let me try that. i did create calculated field. but i couldn't sort and filter some amount..

Here's the result section look , Amount Total will be generated after click on Column level grand total. Should I put some calculation on criteria? my attachment's gone.. hm.