Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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
edited Aug 13, 2024 6:11PM in Oracle Analytics Cloud and Server

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 Acha
    Joel Acha Rank 8 - Analytics & AI 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 & AI 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 & AI 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 Acha
    Joel Acha Rank 8 - Analytics & AI 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 & AI 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.