Mapping

[ritumishra01]

We have fact table with below fields

pgcode

acode

county

pin

amount

we have different pgcode as cw,as,in,ht,hp,in and many more

similarly we have different acode 01,02,04,07

now we need to generate report based on pgcode and acode so we difjned a new field in fact table as combined_field

now what is required is if we select cw pgcode it should include ht,hp,in data as well with all the aid codes 

how to implement this in report data load editor can not do in front end as we are again formung kpi table and pulling that table .

[MatheusC]

@ritumishra01 

What I tried to understand is that you want to combine values into a filter value, like your example, it would be something like this.

if(Match(pgcode,'ht','hp','in'),'cw',pgcode) as new_pgcode


- Matheus