- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Filtering of pivot chart
Hello All,
I would like to learn how to filer pivot chart result.
example.
In my below mention example, I would to filter result base on selection.
Normal Display:
Location Code | Document No | Item Code | Cost Price | Sales Price (BD) | Sales Return |
BR001 | 1 | STK001 | 1,000.00 | 9,000.00 | 500.00 |
BR002 | 1 | STK005 | 1,000.00 | 8,000.00 | 0.00 |
BR003 | 2 | STK004 | 1,000.00 | 4,000.00 | 7,000.00 |
BR004 | 1 | STK006 | 8,000.00 | 15,000.00 | 0.00 |
Filtering records where Sales Return is ZERO
Location Code | Document No | Item Code | Cost Price | Sales Price (BD) | Sales Return |
BR002 | 1 | STK005 | 1,000.00 | 8,000.00 | 0.00 |
BR004 | 1 | STK006 | 8,000.00 | 15,000.00 | 0.00 |
Filtering records where Sales Return is not ZERO
Location Code | Document No | Item Code | Cost Price | Sales Price (BD) | Sales Return |
BR001 | 1 | STK001 | 1,000.00 | 9,000.00 | 500.00 |
BR003 | 2 | STK004 | 1,000.00 | 4,000.00 | 7,000.00 |
To do that:
It will be greate if we can do filtering through User defined value in list box, if not may be any other better way.
I had attached example and modified my main post with result.
Thanks in advance.
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Tushar,
You can take help from the attached application.
Regards,
Tom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for quick reply.
Sorry, I am using personal edition so I am not able to open your file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Based on Tom's suggestion, you can create an extra field to tag zero and non zero sales.
Example
if(Quantity=0,'Null','Not Null') as Filter
Then you can show this field as a value in a list box.
Credit Tom if it helps you.
Regards,
Janzen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
appreciate all of you guys for suggstions.
I had tried them on my example but still struggling in getting result.
I am adding example files, I belive that way I can exaplin what I am looking for ?
As mention earlier I am using personal edition so if you are attaching edited example then let me know how to open or send me suggstion with I will be abel to get result.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
sorry I did not understand your suggestion.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I had tried to create list box with formula which you have mention but result is differing from requirements.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Tushar,
You can use the following attached code in your script.
Regards,
Tom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please see the attached document.
Hope that helps
Regards
Mhatim
- « Previous Replies
-
- 1
- 2
- Next Replies »