That depends on how many columns your pivot table uses. Less columns = less data = lower price.
If the implementation is smart enough it could use BigQuery partitions for further cost savings.
Idiomatic BigQuery will make use of partitioning, so that a large dataset will span multiple tables in a way that you only read the tables of interest. (E.g. the Google Analytics integration partitions by date, so reporting on 1 month of data will only read 30 tables out of the 1,500 you might have.)
Especially with column-based querying and partitioning.