pivotable | columns Filter Drill Totals Default values Convert | Business library

Given dataframe in this format:

I am trying to count the number of times users look at pages in the same session.

I am starting with a data frame listing user_ids and the page slugs they have visited:

As i wanted to conditional formatting of colour scale in the range as shown below, i recorded the macro while doing it. The code will work but i encountered the "procedure is large error"(compile error) when i do the same thing for 36 pivottables. So is there a way to decrease the size of the procedure so that i can do it for 60 pivotables?

The type of conditional formatting that i used for my colour scale

I have 5+ Pivot Tables in a Worksheet where some cells have an empty source cell and are displayed with the typical (blank). I want the pivot tables to display an empty cell instead of the word (blank).

I have reviewed other solutions but they are asking to have empty rows removed or the table filtered etc.

Closest thing I found was under Excel VBA Remove Blanks from Pivotable Group

but in this solution a single column is identified and I need this to be applied to all pivot tables.

Tried just simple recording the macro steps but am getting a Run time error 1004 on the ExecutExcel4Macro line when I try to re-run the macro.

I didn't fount something useful for my problem although it seems to be a common problem. I have a simple old code of mine with a table of compnies data in one sheet. My code takes data based on a company name, finds a worksheet with that compny name inside the workbook and make few actions.

My problem starts when one of the sheets gets deleted and the the code stucks. I do in the code the same routine for every company, and I want it will fo to next company if it not finding worksheet with specific company name.

Can someone help with somthing that will work as an if statement?

Here is the start of the code and two companies for example - YEDIDIM & BEHIRIM. the else is the same:

I have this basic database table and am SQL beginner.

In order to pivot table within sql server, once again iam encountered with limitation. Suppose the following Occupation table contain 3 feature i.e. ID, FirstName, and Occupation, as follow:

Then in order to return pivot base on its occupation i tried the following code:

From a unstructured text, I have extracted all necessary entities and stored it in a dictionary using stanford POS tagger. Now I want to extract the relation between them to build my own Ontology in the form of triplets (Entity1,Entity2,relation). I tried the stanford dependencies parser, but I don't know how to extract these triplets.

For example: The front diffusers comprise pivotable flaps that are arranged between boundary walls of air ducts.

I want to have the relation (front diffusers, pivotable flaps, comprise); (pivotable flaps, boundary walls of air ducts, arrange);

Another example: The cargo body comprises a container having a floor, a top wall, a front wall, side walls and a rear door.

My expected relations are (cargo body, container, comprise); (container, floor, have); (container,top wall, have); (container, front wall, have); (container, side walls, have); (container, rear door, have).

What can I do with the stanford dependencies parser to achieve my goal? This means how to navigate the dependencies parse tree and get the results?

I have a problem trying to do a sales pivot per month and by 30-minute intervals, THIS IS MY RESULT:

As you can see this is not correct, since it repeats the sales of the whole year in each of the months.

I will put my code below, hormod is a time type field and fecalb is a date type field ,