AnsweredAssumed Answered

one table, two graphs???

Question asked by Andrewhubbard on Oct 10, 2018
Latest reply on Oct 11, 2018 by Andrewhubbard

Hi Everyone, I am wanting some assistance please?


I need 2 graphs from one table and I can't for the life of me figure it out.


Am i having a senior moment i ask myself?


I have a stock list of multiple different items but they essentially fall into two categories, either Furniture (beds, wardrobes, mattresses, chests of draws etc) or White goods (cooker, fridge, washing machine etc). I'm trying to construct a dashboard showing me a bar chart with stock levels for each category. I'm using a duplicate table so that my sort order is fixed for the graph but I can't seem to separate the furniture from the white goods.


can anyone help me please?