Forum

Hi Riny, agree PQ is likely the better option if I can get them to agree.

Hi Riny, Thank you. I will explore it further, unfortunately where it will be used they are not that familiar with PQ and also there updated version d...

Hi, I am still having some issues. I have attached a sample file, with the main issue being that the current Ranges for Apr, May and Jun are dependent...

Hi Riny, Thank you, I will try this tonight. As yet I have not set up the file properly.

Thank you to all for the advice. I ended up using Power Query and Power Pivot Table then A Choose formula with 9 variables. Work well and file size no...

Hi Alan, Thank you. I have set up the attached sample. Essentially the User will select the Month (Apr, May or Jun). Then review a report at Divisiona...

Hi Mynda, Thank you, It is somewhat a permanent filter but I think also using Power Pivot with slicers is a good option. If I understand correctly ...

Hi Mynda, That is something I had not though about and I will work on - it might be possible as if multiple Divisions are required they are usually...