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]

Almost closed avinash,

That would be great help if you can help me to get average as am expecting 150.

I wrote expression as for average Sum(value1)/Count(Distinct MonthYr).

Can you suggest me on this whether its correct or wrong???'

PFB for your reference!!!

[avinashelite]

check the attachment

[avinashelite]

Don't forget to mark the helpful and correct answers

[satishqlik]

Hi avinash,

Isn't work same logic for all the scenarios??

PFB for ur reference.

and also am trying to implemant same logic into my exsting data.

But not recognizing subprocess as a field(showing all records in the list box with gray color) 

Sorry for my late replay.

is there anything wrong in my expression?Please suggest on this. !

[avinashelite]

share your actual app , will see that's the issue is

[satishqlik]

Hi Avinash,

Thanks for your quick replay,

am unable to share my actual application.

I have shared my sample(1234.qvw and 1234.xls) PFA for your reference!

In my actual application why its showing in gray color??

same logic I have followed as you suggested.

[avinashelite]

Gray color ?? I am not getting what your trying to say ...the data might not be related ? or your talking about the total showing in grey ?

[satishqlik]

irrespective of related or non related,

By default total showing in the list box with gray color..

[avinashelite]

share the screen shoot ? you mean the aggr tables total is showing Grey ?

[satishqlik]

PFA for your reference!!