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

Removing totals for a fact-column in table view

Morten_J

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

Find more posts tagged with

Accepted answers

All comments

Joel Acha

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.

choracy69

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.

Morten_J

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

Morten_J

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

choracy69

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.

Morten_J

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).

Joel Acha

You'll need to do something along these lines to modify the XML to apply the formatting to a specific grand total cell.

choracy69

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.