There is a way to filter a period A (Filter Panel). Where I have a bar chart that has a period B and Sum(Units). And that I still filter but still show me the totals by periods? For example, if I filter the period 202310. The chart will filter out everything associated with it. So if the Total, without filtering shows me the following: 202301 26,500 202302 15,000 etc. and When I filter 202301 4,000 202302 7,000 etc. What I want is that when filtering I follow them they show 26,500, 15,000.
Please share sample data set and outcome you need, So that we can think to share that is helps.
From above, You are giving data points, but not sure what are they and how that is calculated 🙂
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
I want to Filter 202310, show me the totals that are in yellow in the excel. In the end I need 2 graphics. The one that is already in the example with the October filters for each period version. And the other one shows me the same periods but with their totals (As I said, they are in yellow in the Excel) I hope it is understood. Thank you !!!!
Preview file
14 KB
Filters (Same Filter Totals And Values Period Filter).qvf
