Removing totals for a fact-column in table view — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Removing totals for a fact-column in table view

Received Response
52
Views
8
Comments
Morten_J
Morten_J Rank 3 - Community Apprentice

Hi,

I have a table view in BICS - Answers - Analysis, looks something like this:

                                

DIM MonthDIM - DepartmentFACT Sales AmountFACT Sales Average
01Dep 110010
02Dep 112213
Dep 1 Total22223

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

  • Joel
    Joel Rank 8 - Analytics Strategist

    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
    choracy69 Rank 6 - Analytics Lead

    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.

    pastedImage_0.png

  • Morten_J
    Morten_J Rank 3 - Community Apprentice

    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
    Morten_J Rank 3 - Community Apprentice

    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
    choracy69 Rank 6 - Analytics Lead

    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
    Morten_J Rank 3 - Community Apprentice

    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
    Joel Rank 8 - Analytics Strategist

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

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    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.