Fast change issue in line chart

[#1]

Hi all,

I have one line chart with month and products as dimensions and sum(sales)  as expression.
This line chart is monthly time trend so its displaying sales by month.

Requirement is, in fast change they want pivot table.

but as sequence of dimensions is month, product , when we change the chart to pivot table it shows the table as month and product. But user wants the chart as for each product it should display months in pivot.

Find the attached screen shots for the same.

Is there any way to change the dimensions sequence based on fast change selections.

Thanks in Advance...!!!

[MK_QSL]

You can achieve the same by using a variable, button and three different chart.

Create a variable vShow.

Uses conditional show for three different chart with vSHOW = 1, vSHOW = 2 and vSHOW = 3....

or create three different text box with action to show the three objects.

UPDATE : Use enclose file to see if this will match your requirements.

UPDATE : Use 2nd file also..

[amit_saini]

Hi Priya,

Yes, drag the column header to the right and above the expression(s) until you see a horizontal blue line. Once you see that line you can let go and the dimension should be displayed horizontally. This can take a bit of fiddling around till you position it just right before the blue line shows.

Thanks,

AS

[#4]

If we manually drag the columns in pivot table then when we will again fast change to line chart it will display the chart by product.

But it should always be by months.

[sudeepkm]

it looks like that is not possible having a single chart with fast change option.

But there is a workaround by making transparent text boxes overlay on two chart's (line and pivot) Fast Change icon.

End user will feel as if they click on the fast change icon but they actually are clicking on a transparent text object.

Please take a look at the example attached.

[amit_saini]

Hi Priya,

Could you please share your qvw file .

Thanks,

AS

[MK_QSL]

Have you checked my both attachments?

[#8]

Hi,

I have tried some work arounds. now I am able to fast change to pivot table.Requirement is user wants to fast change to the pivot table and when we click on send to excel this pivot table should export to excel and in excel from that data they wants to create the chart in excel.This is also possible in excel but the issue is if there are 2 dimensions in pivot table then it shows one line for column name also in line chart in excel. Find the attachment for this. Product is the column name and in line chart I dont want the entry for this.

Is there any solution for this so that I can hide the Product column name.

Thanks In Advance...!!!