I have just started working on QV couple of days back. Till now I am very much fine with Ok with creating basic visualization. But now I got stuck in one place
I have 4 columns in my data 1. Recovery State 2. Month 3. No. of transactions and 4. Total Amount.
Recovery State have states like Write Off, Refunded, Charge back etc.
I am trying to create a chart for Month wise transactions however I want chart to calculate the data only for Write Off state.
I can easily do it by creating list box and select Write Off in that however I dont want to create a list box instead I want to put condition by any formula in chart only that it pick data for only given state