Suggest

[satishqlik]

Hi,

Please suggest on my scenario.

load

data2

from<>

Left Join(Data3)

Load Distinct *,Dual(Cal_Year-1 &'/'& Cal_Year, Cal_Year) as FYear,       

         Dual(Month, fMonth) as Cal_Month,

         Dual('Q' & Ceil(fMonth/3), Ceil(fMonth/3))as Cal_Quarter;

LOAD Distinct*,Year + If(Month>=$(vFiscalYearStartMonth), 1, 0) as Cal_Year,

Mod(Month-$(vFiscalYearStartMonth), 12)+1 as fMonth;

LOAD Year([Month-Yr]) as Year,

  Month([Month-Yr]) as Month,

     Category,

     0 as [Training Days (in week)],

     num([Total Revenue (in lakhs)]*100000) as [Total Revenue],

     num([Revenue per HC (in Lakhs)]*100000) as [Average Revenue],

     num([Recruitment Cost per month]*100000) as [Recruitment Cost],

     [Average Annual CTC per head(in Lakhs, Billable & nonBillable)] as [Annual CTC],

     HC as Revenue_HC,

     [CTC Variance],

     [Salary Cost]

FROM

<>;

I have showed dashboard as per categories wise.

Now I have recieved another table with subcategory field with partial sums

i.e.,Category of value=4SubCategories of values(100=25+25+25+25)

I want to show dashboard as it is even after load the subcategory table.

But If I load subcategory table values are not matching.

Any ideas???

[satishqlik]

yes absolutely, I agreed with you.

2000 is the aggregated result of sub process.

[avinashelite]

so that's why we have not mapped it to any sub-process .... why you need the aggr count table (like 2000) ? could get the result from the other table itself rite

[satishqlik]

Avinash help me to close this issue.

now am able to see sub-process in my main table(process) with all the blank values.

I have used identifier under without  single code then in the existing dash board has no changes.

Let me know is it make sense??

Correct me if I did anything wrong.

[avinashelite · Accepted solution]

Identifier is a hard coded value which I had given in '' single quotes in order to identify from which table the data is coming . What you have made is wrong it will take column values as the identifier which will not help us to identify from which table the data is coming ...I did this because after the join we will be not able to check from which table the data is coming .

Hope this helps you to close the thread