ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot table problem (https://www.excelbanter.com/excel-programming/275965-pivot-table-problem.html)

Jaya

Pivot table problem
 
Hi,

I have a pivot table and pivot fields. I can select
different values from the pivot field dropdown and the
pivot table row values will change according to that.I
have five rows and they are all calculated members.
When i change the values/filter in the pivot fields,
i noticed that one more excel session is created. This
happens only when i have the calculated members as rows
which has the following calculation in the cube. I have 3
calculated members which have the following function in
the cube.
Iif([Measures].[Count]0,
Percentile(SetToArray(Crossjoin(
FILTER(
DESCENDANTS([ClientHidden].currentmember,[ClientHidden].
[Analysis Name]),[Measures].[Count]<0),
{[Measures].[Average]})),.9),
NULL)

The other 2 members have functions:
Median(Filter(
Descendants([ClientHidden].currentmember,[ClientHidden].
[Analysis Name]),
[Measures].[Count]<0),[Measures].[Average])

When i have only these two members as rows the session is
not created..
What is the reason for this and how do i avoid creating
sessions?

-Jaya


All times are GMT +1. The time now is 09:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com