Why does a pivot table have a big X and refresh button?

[sarahplymale]

In trying to manipulate pivot tables (in one case to swap the rows and columns) I occasionally get a a big grey X through the middle and a little refresh button and what I was trying to do doesn't work.  What am I missing here about the table and what is allowed and not.

Thanks!

[amit_saini]

Sarah,

Looks like something is wrong in your expression, please check.

Thanks,

AS

[sarahplymale]

Then why would it be okay until I try to swap the rows and columns?

[rwunderlich]

Can you post a screenshot of the table? (Before the problem).

-Rob

[amit_saini]

May be Swaping of rows and columns won't show you desired results.

Thanks,
AS

[sarahplymale]

Here is a shot of the table.  I have month as the dimension and the current and prior FY as expressions, but I would prefer to swap the rows and colums.  Ultimately I want to calculate the % difference from prior year (as an expression), but would visually like that to appear as a row.

[alematex · Accepted solution]

This ussually happens when your trying to show a lot of data or your expression gets slows because using many conditions.

Try to do the calculus in the script and not in the tables.

[rwunderlich]

I'm not sure if you can get what you want from a Pivot table, but you can with a Straight Table. Change the type to Straight Table and check "Horizontal" on the Presentation tab.

-Rob

http://masterssummit.com

http://robwunderlich.com

[ashfaq_haseeb]

Hi,

It may happens due to low ram.

I wonder do you have enough ram?

Regards

ASHFAQ

[sarahplymale]

That does exactly what I wanted!  Thanks so much!!