Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Afternoon all,
I'm struggling with the basics here I'm afraid.
I have a set of data where payments have been made, by each customer, for each month of the year. I can get this into a simple Pivot table and this works fine.
What i would like to be able to do is create a filter - so that the table only reports on policies where the amount has changed during the year. For exmaple Policy 2 (Mr Wallis) had a payment of £40 in August when all of his other payments were £60.
So by filtering on "Policies with a change of payment" I would only expect to see policies 2 and 6.
Can anyone suggest a method?
thanks very much
Chris.
See attached example
Thanks very much.
Works a treat.
I shall research the component parts of your answer to try and learn from it.
aggr(only({<Policy={'=count(distinct Amount)>1'}>} Policy),Policy)
Would it be possible to have it in the script - so that then the flag could be in a list box - allowing the user to select either "all" or just the policies with changes?
thanks again
Really appreciate your help.
Chris
Hi Chris,
just another example, as I love if() more than Set Analysis.
RR
Hi Chris,
best would be to send example file (with source data). Then someone can code the load - script accordingly.
RR
See attached qvw for a script based solution.
Many thanks to both of you.
Much appreciated.