nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Column level total sort and filter

Tony_OAS_Apex_User

Hi , I have pivot, that has Column level total select.

I want to filter the column level total.

Is there any way to get the column level total filtered?

I know that it's already the pivot result data .. but wondering if there's any way to make column level total as a measure from criteria.

thanks~

Find more posts tagged with

Accepted answers

All comments

Federico Venturin - Oracle

Hi @Tony_OAS_Apex_User ,

Could you please share a screenshot of your pivot table and highlight the total that you would like to filter? This will help people in providing appropriate suggestions

Tony_OAS_Apex_User

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?

piviot2.png

Tony_OAS_Apex_User

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.

Mostafa Morsy-Oracle

@Tony_OAS_Apex_User

you can put calculated item or you can use selection step to set the total you like

Tony_OAS_Apex_User

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

Gianni Ceresa

It's quite challenging to imagine what you are working with and understanding what you are trying to achieve.

What product and version are you using? What piece of the tool are you working with? ("classic" analysis, DV workbook, Publisher report)

What is your data source? Semantic model or a dataset?

You apparently couldn't attach a screenshot requested earlier by Federico, the forum should support that, maybe you can give it another try?

Tony_OAS_Apex_User

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 Classic Analysis.

I created Amount Total with FY '2020'+'2021'+'2022' cross the column.

And than tried to put selection step that if Amount Total is exceeding 150. I want to see the first two rows.

FY 2020 2021 2022 Amount

COLUM1 COLUM2 Amount Amount Amount Total
A B 150 0 200 350
C B 100 90 20 210
4A U01 90 10 0 100

Tony_OAS_Apex_User

attachment still not working~ hm.

Tony_OAS_Apex_User

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.

Tony_OAS_Apex_User

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?