Forum Discussion

bkr's avatar
bkr
Icon for Helper I rankHelper I
3 years ago
Solved

Highlight significant changes to previous month in matrix visual

Hi, is it possible to highlight changes above e.g. 10% vs. the preceding month in a matrix visual? The result is expected to look like this:   January February March April Sales 10000 ...
Need Help
  • olgad's avatar
    olgad
    3 years ago

    Then,  use Sum(Amount)   instead of YOURMEASURE

bkr's avatar
bkr
Icon for Helper I rankHelper I
3 years ago

Thanks, Olga!

yet I don't get it yet. What is [yourmeasure]?  It doesn't seem like calculate accepts a column as first argument.

 

My data has the following columns:

Table Facts:

[Line item]: Sales, variable costs, fixed costs, overhead costs

[Amount]: numbers listed above

[calendar]: Year and month

[EBIT]: is a calculated column

  • olgad's avatar
    olgad
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Sum(Amount) is your measure, your numbers ,what you are displaying.

    line items, what do you mean, those are the values in a column? or those are separate columns?