Hello,

Appreciate if anyone can provide some guidance for my question. Let's say I got a report below. But I need to insert additional layers when a set of action is performed. The layers will only be added when user selected "Project Detail" picker. That's the first condition. Second condition is the layers will only insert to "Application Design, Dev, & Support".

Third, added layers are the 4 project scopes that are not existed in any data sets before. We only want to make existing projects under "Division-wide" and still showing the rest of project scopes but with blank values. Any idea? Thanks!

Hi @Alex Ng, I'm going to have your question moved to the CT Product space so we can see if we can get an answer for you.  

@Brandon Walshin, can you get Alex' question added to the CT Product space where it's more likely to get a response?

Thanks.

I have the question moved to the CT product hub. Please let me know if I can help with anything else.

Brandon

Did it automatically notify Alex where it was moved Brandon?

It should have as he is the owner of the post.

@Oliver Smith,

Hey Ollie,

Are you still the report magician?  Any ideas on whether this can be done?  I'm hoping someone from the CT team will jump in, but thought this might be the kind of problem you might have tackled. 

Deb

Hello! @Alex Ng

Sorry it's taken a while for me to reply, but I have an idea of what you can do  I find it easier to solve these problems by playing with the data itself so forgive me if it doesn't work exactly right

I don't use pickers very much, but I think they add the column that is in the picker? So, I would create the column 'Project Detail' or 'Project Scopes' (whatever you'd like to call it) in the data set you are using, and only fill it in next to the "Application Design, Dev, & Support" ones that you want to give the scopes to. This could be done in another mapping table and looked up in the table you are reporting from.

E.g.

Project Parent                                 | Project Name      | Project Scope

Application Design, Dev, & Support | Billable IT Project | Division Wide

Might be best to use the project code but wasn't sure if that was available.

Then, when you click on Project Detail/Scope, it should add that column and show the scope for each line, and be blank for any that aren't in the App Design bit. If you'd like to call out that they don't have a scope, add 'No Project Scope' to everything else that isn't in App Design. 

I think you can then add the Project Detail/Scope column to the grouped section so that it appears in the 'Service' column along with the other bits of detail (as I think that's where you'd want it) but I have had issues with adding picker columns to that sort of thing before. 

If I've completely missed the mark, you've already done it, or I'm just really confusing, please do say!  I'll try to come back and explain more if needed, but hopefully this will help if you haven't already managed to get it done.

Thanks @Debbie Hagen for following up with my question!

Hi @Oliver Smith

Nice one. Thanks for sharing your ideas! Unfortunately my team decided not to insert the dummy rows anymore. But I am glad if this post can assists the rest of community here