How to display a Web chart for a Query when it has much data
When I am trying to publish a query in Web as Web chart, it says too much data in it.
In Rows I have 3 selections of Product Format(A,B,C)and Products. so in each Product Format there are no.of Products.
In Columns there are 6 Key figures.
The values are diplayed aginst each product and sub totals are calculated on each Product Format.
In my Graph
I want to have dataseriies as Product Formats and all key figures are data points.
When I am trying to display web Chart, it says too much daat in it.
Appreciated your help.