# Is there a workaround so that I can basically run both a Period Variance and Stream Variance in the same report?

**URL:** https://pug.phocassoftware.com/t/is-there-a-workaround-so-that-i-can-basically-run-both-a-period-variance-and-stream-variance-in-the-same-report/897
**Category:** Ask the Community
**Tags:** howto
**Created:** [February 11, 2019, 4:04am UTC](https://pug.phocassoftware.com/t/is-there-a-workaround-so-that-i-can-basically-run-both-a-period-variance-and-stream-variance-in-the-same-report/897 "2019-02-11T04:04:12Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![jackiestuart](https://avatars.discourse-cdn.com/v4/letter/j/3bc359/32.png) [@jackiestuart](https://pug.phocassoftware.com/u/jackiestuart)
#### Post date: [February 11, 2019, 4:04am UTC](https://pug.phocassoftware.com/t/is-there-a-workaround-so-that-i-can-basically-run-both-a-period-variance-and-stream-variance-in-the-same-report/897/1 "2019-02-11T04:04:13Z")

</div>

Hi all,

I have a report showing contracted sales compared with invoiced sales, which is running with a mode of Stream Variance. Is there a way to view this in a YTD / Year on Year variance without actually changing the mode to Period Variance (and effectively losing the Stream Variance view)?

---

<div class="post-metadata">

### Author: ![ShaneAngel](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/shaneangel/32/68_2.png) [@ShaneAngel](https://pug.phocassoftware.com/u/ShaneAngel)
#### Post date: [February 11, 2019, 11:10pm UTC](https://pug.phocassoftware.com/t/is-there-a-workaround-so-that-i-can-basically-run-both-a-period-variance-and-stream-variance-in-the-same-report/897/2 "2019-02-11T23:10:26Z")

</div>

If I am understanding the request correctly, it sounds like its something you may have to build in the custom mode.

---

<div class="post-metadata">

### Author: ![jackiestuart](https://avatars.discourse-cdn.com/v4/letter/j/3bc359/32.png) [@jackiestuart](https://pug.phocassoftware.com/u/jackiestuart)
#### Post date: [February 13, 2019, 1:08am UTC](https://pug.phocassoftware.com/t/is-there-a-workaround-so-that-i-can-basically-run-both-a-period-variance-and-stream-variance-in-the-same-report/897/3 "2019-02-13T01:08:28Z")

</div>

Darn. That’s what I thought. Thanks for replying Shane

---

<div class="post-metadata">

### Author: ![StuartH](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/stuarth/32/394_2.png) [@StuartH](https://pug.phocassoftware.com/u/StuartH)
#### Post date: [June 12, 2019, 4:44pm UTC](https://pug.phocassoftware.com/t/is-there-a-workaround-so-that-i-can-basically-run-both-a-period-variance-and-stream-variance-in-the-same-report/897/4 "2019-06-12T16:44:08Z")

</div>

Are you talking about the “Period Stream” option that allows you to see the same view as the Period Variance but swap the “Previous” for another Stream?

If instead you want to see both streams as they are this year vs last year then yes it’s Custom but you’ll probably want Totals only as it would get to be a quite big table otherwise if you have every month too.

My advice would be to start with the Stream view with the two streams you want to compare and a YTD variance then go into Custom and manually add the prior year by cloning the columns and changing the date range. Finally add the Variance calculation and you’re done.

---

<div class="post-metadata">

### Author: ![ShaneAngel](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/shaneangel/32/68_2.png) [@ShaneAngel](https://pug.phocassoftware.com/u/ShaneAngel)
#### Post date: [June 17, 2019, 3:00am UTC](https://pug.phocassoftware.com/t/is-there-a-workaround-so-that-i-can-basically-run-both-a-period-variance-and-stream-variance-in-the-same-report/897/5 "2019-06-17T03:00:34Z")

</div>

Yep, this is a good suggestion, if you can get your report close to what you need before entering Custom mode most of the work is done for you and you just need to tweak it slightly. 👍
