Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need help with creating table (urgent)

  Metric             Current Year     Previous    Year Difference Total Sales       $X (2022)        $Y (2021)    +% Change Average Sales  $A (2022)       $B (2021)    +% Change Min Sales  ...
AnthonyGenovese's avatar
AnthonyGenovese
Icon for Resolver III rankResolver III
3 years ago

You will need to provide more detail in order to get help. Are you trying to create a visual? A calculated table? What have you tried so far? What isn't working about it? What base data table & columns are you trying to reference?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I am trying to create a table or matrix visual, all i have is total sales and date column.

I tried creating measures for total,average,min and max sales for current year(2022) and previous(2021) but i cant get it in that format