Source data from excel

[former_member402770]

Hi Experts,

Iam using refering source data excel-source.jpgattached from Excel to WEBI. l donot wanted to use excel as dataprovider to arrive this report.

Formula to be created in webi as follows:

1) When i select YSGSL in Emp prompt, the report block should display like below:

EmpGrp Emp Amt

GDSUR YSGSL 4

GDSUR Total 4

2) When i select YTYDEG in EmpGrp prompt, the report block should display like below:

EmpGrp Emp Amt

TYDEG JJSDS 1

SDADF 2

EWEFV 3

TYDEG Tota 6

Can you help formula for above two cases

Thanks,

Dinya

[jyothirmayee_s]

Hi,

As Sven mentioned, you don't need formula.

Did you merge on EmpGrp and Emp Field (Excel and from other source)?.

Create input control on merged EMPGrp and have optional prompts.

That way if user selects any EMPGrp, they will see only the selected employee Amount and they dont then "All" EmpGrp will display.

Thanks,

Jothi

[former_member402770]

Hi Sven,

I have EmpGrp and Emp field coming from an data provider, I want to populate measure amount column values from excel source which includes the EmpGrp and Emp field.

How to write a formulae logic to get Amt relevant to EmpGrp and Emp field upon any of these selections in prompt. If I run the report without prompt selection all Amt should get display . Previuos i attached the excel source.

Thanks,

Dinya

[sven_oehme]

Hi Dinya,

Should this be your source or is this an example for the visualization? What you need is not a formula to display. If you use normal structured source data, the dimensional functions will do the job. Just fill the grouping of "EmpGrp" and remove the totals. Then you just need to select the "Emp" in promt or input and build a summary-line.

Grtz

Sven