Exact Rate in Pivot Table Column With qty & Total Value

[RAMU]

Dear Friends,
I hv a data like the following:

pur date	fruit	supplier	rate	qty	value
15-12-2019​	apple	v r ent	50​	26​	1300​
20-01-2020​	apple	w r fruit	60​	24​	1440​
14-09-2019​	banana	w r fruit	40​	35​	1400​
15-03-2020​	banana	s m fruit	60​	33​	1980​
14-11-2019​	guava	care	30​	54​	1620​
02-08-2020​	guava	v r ent	35​	39​	1365​

I need to put exact rate in column level along with the suppliers' name also in column level. Also total value will be shown. In case if required I may add qty & pur date also. Pur date & fruit would be in Row level. Pur Date should come as newest to oldest.
Pls help. I need to know the process also.
Thanks in advance
Regards
RAMU

 

[RAMU]

Dear Friends,
I hv a data like the following:

pur date	fruit	supplier	rate	qty	value
15-12-2019​	apple	v r ent	50​	26​	1300​
20-01-2020​	apple	w r fruit	60​	24​	1440​
14-09-2019​	banana	w r fruit	40​	35​	1400​
15-03-2020​	banana	s m fruit	60​	33​	1980​
14-11-2019​	guava	care	30​	54​	1620​
02-08-2020​	guava	v r ent	35​	39​	1365​

I need to put exact rate in column level along with the suppliers' name also in column level. Also total value will be shown. In case if required I may add qty & pur date also. Pur date & fruit would be in Row level. Pur Date should come as newest to oldest.
Pls help. I need to know the process also.
Thanks in advance
Regards
RAMU

Is it not possible friends ? I am unable to do, tried lot.

 

[RAMU]

Is it not possible friends ? I am unable to do, tried lot.

It seems that not possible. Should I think so friends ?

 

[RAMU]

It seems that not possible. Should I think so friends ?

No help friends