Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Removing totals for a fact-column in table view

Hi,
I have a table view in BICS - Answers - Analysis, looks something like this:
DIM Month | DIM - Department | FACT Sales Amount | FACT Sales Average |
---|---|---|---|
01 | Dep 1 | 100 | 10 |
02 | Dep 1 | 122 | 13 |
Dep 1 Total | 222 | 23 |
Totals After has been set for DIM - Department to get a row for totals.
Problem:
I only want the totals for column FACT Sales Amount, for FACT Sales Average I want the sum column to be blank.
How can I do that?
Have tried setting "Treat as an attribute" for FACT Sales Average, that does not work.
Any pointers will be highly appreciated!
Thanks,
Morten
Answers
-
Quick way to do this would to be format the colour of the other total to blend into background as I don't believe you have that level of control on totals.
0 -
Hi,
Ok you have a Grand Total after values that on column Sales Average please check (in Edit Formule) on Aggreation Rule(Totals Row): None and this it all.
0 -
Thanks,
I guess I would then need to use Conditional Formatting on FACT Sales Average.
How would I identify which cell is the totals row in Conditional Formatting?
I still want to see the value for FACT Sales Average for the rows 1 and 2.
Morten
0 -
Thanks choracy69,
Agree, this should do the trick, but if I do this, then no values are retrieved for some reason.
It blanks the entire column.
Morten
0 -
So if you check None on aggregation rule you get no value in all column?
How you create this column? In rpd set a Aggregation? You have maped this column or using expression?
This is not a trick, it's normal functionality.
0 -
Yes, all column values are blanked when I set None.
No aggregation in rpd, and column is mapped (tried with expression as well, same thing happens).
0 -
Ok, that how you create column? Describe here, what is the formule in RPD, why you dont' use aggreagtion in RPD and maybe what is your formule in analysis?
I used column with expression(expression create in RPD) use NONE aggreagtion rule and it's working fine.
0