Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Column level total sort and filter
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~
Answers
-
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
0 -
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?0 -
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.
0 -
you can put calculated item or you can use selection step to set the total you like
0 -
ok.let me try that. i did create calculated field. but i couldn't sort and filter some amount..
0 -
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?
1 -
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 AmountCOLUM1 COLUM2 Amount Amount Amount Total
A B 150 0 200 350
C B 100 90 20 210
4A U01 90 10 0 1000 -
attachment still not working~ hm.
0 -
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.
0 -
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?
0
