Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Calculating in visualisation

Hey,   I want to calculate with the data in the table in 'Report'. The data in the table is grouped by through the visualisation, so I can't use the data. How can I use the data in the table to cal...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Didn't work man. The result needs to be 48-11 = 37 and not 15. Do you got another idea?

 

SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

Capacity and total forcast are measures?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

     

    • SpartaBI's avatar
      SpartaBI
      Community Champion
      4 years ago

      ok, so thery are columms and you did implicit measures on them. 
      How are they aggregated in you visual? SUM / AVERAGE?
      If it's not just sum then you need to create explicit measures for them and them just reduce 1 measure from the other