Hi Chester, if you copy and paste this spreadsheet and you change the data on the table, say weekly or monthly, does the code you put in automatically update the pivot table or does it pick up the original cache?
Text values in value field gets converted to number.. But i want it to remain as text... I have recorded it by adding data model and using ConcateneX but this doesn't work for other sheets. Please tell me the code to add datamodel and give text in value filed.
what if I wanted to add the pivot table to a separate workbook
Thank you so much ❣️❣️❣️
Thank you so much sir 😌😌😌
Hi Chester, if you copy and paste this spreadsheet and you change the data on the table, say weekly or monthly, does the code you put in automatically update the pivot table or does it pick up the original cache?
NICE video But if I have to add 2 values in One Row Field Then what we do
Nice video. Easy to understand sir.
Thank you sooo much!
Can you also show how to add a pivot chart to this same pivot table?
Very useful video to us., but in the code "with PT" throwing an error like variable not set. Could you help me please
Hi
Thanks a lot for the great video, could you explain what Is the purpose of (.orientation =xLRowField, xLColumnField, xLDataField)
Thanks
Please Update this Both Videos..
How to Extract Month Name from Data Of overall Data of Large siza
Text values in value field gets converted to number.. But i want it to remain as text... I have recorded it by adding data model and using ConcateneX but this doesn't work for other sheets.
Please tell me the code to add datamodel and give text in value filed.
How To Extract Month name From Overall Data of large Size
How to add filter to the page filter with vba
I can't see off the edge of the screen
PLEASE Update This Video