3 Replies Latest reply on Feb 6, 2019 3:11 AM by Jim Dehner

# How to display the product wise sales in butter fly chart

Hi All,

I want to display the product wise sales in butter fly chart where user is asking for two filters for week, tow filters for month & Year and two filters for Year.

By using this filters user can select any two random week or two random month&year. Suppose user selected week no 10 of 2014 in first filter and week number 15 of 2017 in second filter

so data should show the the comparison of sales like week number 15 (sales) - Week number 10 sales and it will plot in percentage like below

below chart is for reference only.

User don't want to show the data between week number 10 to week number 15. He wants to plot only two different weeks or months selected by user

• ###### 1. Re: How to display the product wise sales in butter fly chart

Good morning

Filters are used to limit the data available in the table that underlays the worksheet

once the data is filtered out it is no longer available for use -

so what to do - you can use sets thied to parameters to have 2 data for 2 separate dates (or products) and then use the sets in your other calculations

similar to how you would use a filter

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 2. Re: How to display the product wise sales in butter fly chart

Can you please help me with one sample workbook . Currently i have created two parameters for Week selection First week and Second week and created the calculated filed for it as below

ZN(IF [First week]= [Week] THEN [Meter Reading] END)

ZN(IF [Second week]= [Week] THEN [Meter Reading] END)

Then created one more calculated field as below

(SUM([Second Week])-SUM([first week])) / SUM([first week])

to compare the meter reading in percentage now it showing the results.like below

• ###### 3. Re: How to display the product wise sales in butter fly chart

there was not book attached