Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Excel tables that have data as follows:
Sales Data:
Account Invoice Number Invoice Date Year Month Product Quantity Invoice amount
1815 3626226 12/30/2013 2013 12 148 224 $35,204.40
Product Data:
Product Product code Product category Product category code Standard price
Jescie 252 5 Music and entertainment $183.00
Variable cost Gross margin Year
$54.90 128 2010
Customer Data:
Customer name Country Region Customer Number
Ac Mattis Semper LLC United Kingdom GNM 1606
Sales Budget:
Year Month Account Product code Budget
2010 1 1038 250 72,201
I would like to create a bar chart showing Product Category by Invoice Amount (Sales), but I keep getting 'no data to display'. I have set the dimension as Product category code and set Invoice amount to dollars format. I am not sure what I am doing wrong.
Thank you in advanced for help
I have just figured out that when I try exactly the same thing for sales budget per product category instead it works. Does anyone know what could be going on?