Forum Discussion
HOw to use, IF, AND, Lookup, match, maybe all or none of these!
Good evening/morning, I could do with some help on the example workbook I have added. What I am trying to acheive is this:- Include all of the relevant invoice numbers from sheet 2, onto shee...
Thanks Detlef Lewin, any chance of a video to show me how to set this up?
There is this thing called web search.
https://www.google.com/search?q=add+data+model+pivot+table
https://www.google.com/search?q=add+text+to+values+area+of+a+pivot+table
- Detlef_Lewin
Many thanks for this. I did turn to google in the first ance before my previous reply, and have looked at the 2 pages you have sent. As I am a complete rookie on pivot tables, I have struggled puttting it together like you have. I am able to make a pivot table, but need help getting the data from sheet 2, and really do not understand DAX measure. Are you able to provide a step by step guide at all please?
I am getting the error 'a table can''t overlap another table'The web search gives you many step by step tutorials either as text or as video.
It's all there and I could not explain it better than those experts.
And regarding your error: Your pivot table needs more rows/columns and there are not enough blank rows/columns between your pivot tables.
Either add more blank rows/columns between your pivot tables or move one of the pivot tables onto another sheet.
https://www.google.com/search?q=a+table+can%27%27t+overlap+another+table
https://www.google.com/search?q=move+a+pivot+table+onto+another+sheet