Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Pivot Tables - Blank
Options
Go to last post Go to first unread
Previous Topic Next Topic
Nj_young  
#1 Posted : Thursday, August 13, 2020 7:29:22 AM(UTC)
Nj_young
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 84

Thanks: 2 times

I am generating GW elevation tables using the pivot table function. When data is not available, cells are populated with "blank". Is there any way to have this actually blank or report as a dash?

Nick
Back to top

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
Nick Tumney  
#2 Posted : Thursday, August 13, 2020 10:05:12 AM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 327
Canada

Was thanked: 29 time(s) in 29 post(s)

Hi Nick,

Can you please include some screen captures of what you are seeing, and what you would like to see?

I'm not really following what you're trying to achieve, so some visuals might make this a bit easier for me to understand.

Cheers,

NT
Back to top
WWW
Nj_young  
#3 Posted : Friday, August 14, 2020 11:26:30 AM(UTC)
Nj_young
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 84

Thanks: 2 times

Table 2 - Groundwater Elevations.xlsm (18kb) downloaded 5 time(s).I have attached the pivot table. The cells in question are elevation (renamed GS) and TOC. We have no data for DP1 and thy report as "(blank)". Is there any what to avoid this? 

Is it possible to have all cells for which no data is available be filled with a dash?

Nick
Back to top
Nick Tumney  
#4 Posted : Monday, August 17, 2020 1:00:02 PM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 327
Canada

Was thanked: 29 time(s) in 29 post(s)

Hi Nick,

To confirm that I understand correctly, you have exported the data from ESdat Desktop to Excel using the Pivot Table export:

Pivot_.PNG (23kb) downloaded 0 time(s).

Where there is no data in ESdat it displays in the Excel file as (blank):

pivot_blank.PNG (2kb) downloaded 0 time(s).

ESdat is utilising the standard pivot table funcitonality in Excel, so unfortunatley there is nothing we can do about this as it is due to the grouping in Excel.

If your aim is to use the pivot table as a report, you can copy and paste values into a new sheet, and then format it however you like as it will now just be values you can edit.

Cheers,

NT

Back to top
WWW
Similar Topics
Creating Pivot tables in ESdat web (ESdat)
by paige_spurgeon 4/20/2022 1:45:15 AM(UTC)
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET