Chart in Crosstab

[Gauravbi]

Hi All,

I am facing a issue to create a graph in cross-tab report.
My measures are all calculated and there is filter on achievement.
And data is coming in report but not showing in graph.
Because query result also coming blank when filter is applied.
Without filter data is coming in query, report and graph.

Please suggest me to how to show calculated data in graph.

Thanks
Gaurav

[MFGF]

Hi,

Are you reporting from a relational package or a dimensional package? I'm not completely clear on your issue, but it seems like you are saying when you apply a filter to the query of the report, no data is being returned? That most likely points to the filter being incorrect somehow. It's impossible to say what's wrong without knowing more detail, though.

MF.

[BigChris]

There's obviously something wrong with your filter if your report, query and graph all work fine without it. Can you post the content of your filter and what you're hoping to achieve with it? Don't forget to let us know if you're applying the filter before or after aggregation.

[Gauravbi]

Hi,

My report is like this


                                   Net sales  | Returns Sales |   Returns | Count1| Count2 | count3
Sales Person    | P1       10000    |      220          |    2.2 %   |     1      |    0       |   0
                        | P2                                             |    0.1 %   |     0      |    0       |   1
                        | P3                                             |     1.5 %  |     0      |    1       |   0

All measures are calculated figures Net sales, Returns sales and Returns and counts are buckets on returns.
and there is a filter on returns like Returns > 0.05 after aggregation.
If I apply aggregation on sales person I get proper figures in Total.
Now I want to show total of Count1, total of Count2 and count 3 in graph (Pie - Chart).