S
stakar
I have a pivot table that depends on a column like this
A
---
00
11
01
11
01
00
00
10
01
00
10
00
10
10
01
00
20
00
00
00
The pivot table gives me the results
XX How many times
---------------------
00 9
11 2
01 4
10 4
20 1
-----------
Total
Sum 19
#First Question
I want, when i just click with my mouse on each cell of the above pivo
table's column XX
to be created a table like style, that would contain the values wit
the appearance
of each next value to clicked value.
Be more specific using an example:
If i click on 00 i want to look for every NEXT value that is comin
RIGHT AFTER the 00
on column A and how many times this it happens.
The table which would be created is..
Value How many times
00 3
10 3
11 1
20 1
------------------------------
If i click on 10
The table which would be created is..
Value How many times
00 1
01 1
10 1
------------------------------
If i click on 20
The table which would be created is..
Value How many times
00 1
------------------------------------------
#Second question
Using the above column A and pivot table , when i click to the cell X
on pivot table i want
to trigger another event too.
I want to look for the selected value in column A and counting how man
times the same value
comes consecutively, starting of 2 times then 3,4,5 ending to 10 an
bigger than 10
Be more specific using an example:
If i click on 00
The table which would be created is..
Consecutively
times How many times '00' has come
------------------------------------------
2 2
3 1
4
5
6
7
8
9
10
If i click on 10
The table which would be created is..
Consecutively
times How many times '10' has come
------------------------------------------
2 1
3
4
5
6
7
8
9
10
Mention that, If it has come consecutively 4 times also has come 2 an
3 times
If it has come consecutively 3 times also has come 2 times
If it has come consecutively 7 times also has come 6,5,4,3,2 times
I hope you understand
Thanks in advance
*****************************************
Stathi
A
---
00
11
01
11
01
00
00
10
01
00
10
00
10
10
01
00
20
00
00
00
The pivot table gives me the results
XX How many times
---------------------
00 9
11 2
01 4
10 4
20 1
-----------
Total
Sum 19
#First Question
I want, when i just click with my mouse on each cell of the above pivo
table's column XX
to be created a table like style, that would contain the values wit
the appearance
of each next value to clicked value.
Be more specific using an example:
If i click on 00 i want to look for every NEXT value that is comin
RIGHT AFTER the 00
on column A and how many times this it happens.
The table which would be created is..
Value How many times
00 3
10 3
11 1
20 1
------------------------------
If i click on 10
The table which would be created is..
Value How many times
00 1
01 1
10 1
------------------------------
If i click on 20
The table which would be created is..
Value How many times
00 1
------------------------------------------
#Second question
Using the above column A and pivot table , when i click to the cell X
on pivot table i want
to trigger another event too.
I want to look for the selected value in column A and counting how man
times the same value
comes consecutively, starting of 2 times then 3,4,5 ending to 10 an
bigger than 10
Be more specific using an example:
If i click on 00
The table which would be created is..
Consecutively
times How many times '00' has come
------------------------------------------
2 2
3 1
4
5
6
7
8
9
10
-------------------------------------------
If i click on 10
The table which would be created is..
Consecutively
times How many times '10' has come
------------------------------------------
2 1
3
4
5
6
7
8
9
10
---------------------------------------------
Mention that, If it has come consecutively 4 times also has come 2 an
3 times
If it has come consecutively 3 times also has come 2 times
If it has come consecutively 7 times also has come 6,5,4,3,2 times
I hope you understand
Thanks in advance
*****************************************
Stathi