asked on

Check Pivot table

Hi,
Within Excel 2010, how can I see the details of the column/field of one Pivot table?

Right click in value area of a field and choose Show details.
Edit: You may also double click a value to get the details.

Peter Chan

ASKER

To the Excel below
https://dl.dropboxusercontent.com/u/40211031/KPI-MON%202016%20JAN%20Jan%206.xls

within "KPI" sheet, I want to know where the relevant query (or something) is, which is producing the definition of "KPI" sheet, as it does auto refresh the Excel sheets, once I've pressed

Data > Refresh

on menu.

Peter Chan

ASKER

Please let me know if you cannot access the Excel file. Thanks

SOLUTION

Subodh Tiwari (Neeraj)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Peter Chan

ASKER

Within KPI sheet, C column now is having

=WEEKNUM(B?,1)

How to adjust it?

Does it mean we directly adjust column, for instance, if we need to alter the definition of specific columns?

Subodh Tiwari (Neeraj)

Still not sure what are you trying to do.

In C2 you have the formula =WEEKNUM(B2,1) which returns the Week Number of the Date in B2 and the formula in C2 is copied down.
The formula assumes your dates are in column B. So if your date column is different from column B, say col. A, you would be required to change the formula to =WEEKNUM(A2,1).

Peter Chan

ASKER

I want to adjust it to be

=IF(B2="2016-1-1" OR B2="2016-1-2",53,WEEKNUM(B2,1)+1)

Open in new window

to Column C. What should be the correct syntax?

Peter Chan

ASKER

While B2 is one Date field.

ASKER CERTIFIED SOLUTION

Subodh Tiwari (Neeraj)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial