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.
