Oracle Analytics and AI

2999400

Hi, OBIEE experts.

For your kind assistance, how can i do this in OBIEE:

Where in Daily average is computed by RSUM / Calendar Day. every time i try to add field1 & field2 in my pivot table i got different result for my RSUM.

   

	Field2 value1			Field2 value4
	Field1 value1			Field1 value4
Date	Revenue	Daily Average	RSUM	Revenue	Daily Average	RSUM
3/1/2016	10	10	10	20	20	20
3/2/2016	11	10.5	21	21	20.5	41
3/3/2016	12	11	33	22	21	63
3/4/2016	13	11.5	46	23	21.5	86
3/5/2016	14	12	60	24	22	110
3/6/2016	15	12.5	75	25	22.5	135

Thomas Dodds

Field2 Value1 & Field1 Value4 are adding what value to the information displayed?  It is unclear given how you've represented your pivot table.