I have a field called 'CRDTeamFlag' and the options are 'CRD Team' or 'Non-CRD Team'.
I have one chart for CRD Team and one for Non-CRD Team.
In my NP report, I want 1 tab to show the entire Non-CRD Team chart, one tab for the entire CRD Team, chart and then PAGING (1 tab) for each Person in the CRD Team. In other words, 2 summary tabs (team and not team) and one tab for each person on the team. Thoughts?
not sure about template you want to use as you are not indicating it. Lets assume it is excel. I can see it working like this:
use one chart (instead of 2 separate prefiltered charts) without any set analysis or filtering as you can use page tag to achieve filtering...
Build first (1-one) excel sheet with page applied on it using CRDTeamFlag
Build second sheet (also one sheet) with applied page on it using table as a page object with CRDTeamFlag and Person as dimensions
It looks quite straight forward i think.
If my understanding is wrong maybe try to attach sample with how the outcome needs to look like...
cheers Lech, 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 to the problem.
not sure about template you want to use as you are not indicating it. Lets assume it is excel. I can see it working like this:
use one chart (instead of 2 separate prefiltered charts) without any set analysis or filtering as you can use page tag to achieve filtering...
Build first (1-one) excel sheet with page applied on it using CRDTeamFlag
Build second sheet (also one sheet) with applied page on it using table as a page object with CRDTeamFlag and Person as dimensions
It looks quite straight forward i think.
If my understanding is wrong maybe try to attach sample with how the outcome needs to look like...
cheers Lech, 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 to the problem.
Page tag loops through values in the field. So why do you want to apply filter. It will look through CRDTeamFlag = 'CRD Team' and CRDTeamFlag = 'Non-CRD Team'.
Do you have any other values in this CRDTeamFlag field? From your description it looks like you only have those 2 above mentioned values so you just need to use this field as <page> tag and it will loop through it.
If you have other values in i then apply filter on whole report. Filter would be then CRDTeamFlag = 'CRD Team' , 'Non-CRD Team'
cheers Lech, 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 to the problem.
